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(da y)+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.