# Date lists

M

#### Mokka

In Excel 2003 I wish to create a list where cell A1 contains a starting date
with a formula in cell A2 that has the same day in the next month same year
Cell A3 continues the list
e.g. A1 = 01/01/2009, A2=01/02/2009, A3=01/03/209
I have used the formula
=DATE(YEAR(year)+value1,MONTH(month)+value2,DAY(day)+value3) as described in
various other ares BUT when the date in A1 is 31/01/2009, cell A2 displays
the date as 04/03/09.
The formula also need to show that if A1=31/01/2009, then A2=28/02/2009,
A3=31/03/2009.
Also need to account for leap years
All help appreciated.

S

#### Stefi

In A2:
=EDATE(A\$1,ROW()-1)
and fill it down! Analysis Toolpak is required to use this function!

Regards,
Stefi

â€žMokkaâ€ ezt Ã­rta:

M

#### Mokka

So easy!
Many Thanks

Stefi said:
In A2:
=EDATE(A\$1,ROW()-1)
and fill it down! Analysis Toolpak is required to use this function!

Regards,
Stefi

â€žMokkaâ€ ezt Ã­rta:

S

#### Stefi

You are welcome! Thanks for the feedback!
Stefi

â€žMokkaâ€ ezt Ã­rta: