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:
Click to expand...
 

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

Similar Threads

Dates In Excel 5
date mismatching 2
copying_data_using_FillHandle 1
How to get largest date from a Vlookup 1
Generating date from day, month year 4
Termination within number of days 6
Subtracting time...again 2
One text for particular period 5

Top