Years calculation (2003)

Hi there
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.

Re: Years calculation (2003)

Re: Years calculation (2003)

You can also do this without formula:
In the first cell, enter 1 June 2009.
In the cell below it, enter 1 June 2010.
Select these two cells, then fill down for another 98 cells by dragging the fill handle in the lower right corner.

Re: Years calculation (2003)

In teaching any Windows-based application, I tell my clients "There are 4 ways of doing everything", and "If you don't know all 4, you probably aren't using your computer efficiently",
but FIVE ways to fill succesive years?
You guys take the cake! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>