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.
 
Ad

Advertisements

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:
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top