Date Range Question

[johnsoncj2002]

I want to type in a date in A1 and then A2 calcualtes the following month....and so on.

Example: A1 = 4/1/2012 and the A2 returns the value 5/1/2012....A3 would be 06/1/2012 and so on.

[arthurbr]

In A2 enter =date(year(A1), month(A1)+1,day(A1)), etc...

[Richard Buttrey]

Hi,

In Excel 2007-->

=EOMONTH(A1,0)+1

in 2003

=DATE(YEAR(A1),MONTH(A1)+1,DAY(1))

[JieJenn]

Copy and paste this formula in A2 and drag it down

=DATE(2012,ROW()+3,1)