Adding a month to a series of dates

[Andy Sandford]

Hi

I'm probably being stupid, but here's my dilemma! 8o)

I have a date in cell A1, say 19/3/04 and I need to fill in the next 35
dates automatically - each being incremented by exactly one month:

19/4/04
19/5/04
19/6/04

....etc

I can't figure out an easy way to do this, such as adding a fixed number of
days, as each of the month's have a different number of days.

Any ideas?

TIA

Andy

 

[Guillermo]

fill in A1 with 19/03/04
fill in A2 with 19/04/04
select both
put the mouse pointer in the lower right corner of the selection (you'll get
a black cross) and drag it down using the left button

I'm not sure of an easy way to do it with a formula


guillermo

 

[Arvi Laanemets]

Hi

More general way (when in following month is less days as starting month
date, last day of month is returned)

With start date in A1
A2=MIN(DATE(YEAR($A$1),MONTH($A$1)+ROW()-1,DAY($A$1)),DATE(YEAR($A$1),MONTH(
$A$1)+ROW(),0))
and copy A2 down.


Arvi Laanemets