I want to put a date (day month year) on every column ... In one cell I have a date .. 1 June 2009.. In the next cell I put =a1+365. That works ok until you hit leap years. I have to do 100 years.
Is there a formula to do this ???? Because after 80 years it jumps to May.