Another "working with dates ?"

  • Thread starter Thread starter giffer
  • Start date Start date
G

giffer

Hi,
I want to create a list of dates one month apart from cell A1 thru
A200. In cell A1, I have the date of April 1, 2006. I need a formula
that copies A1 and adds one month to cell A2 thru A200.
Example
A1 April 1, 2006
A2 May 1, 2006
A3 June 1, 2006
A4 July 1 2006

Any suggestions will be appreciated
giffer
 
Hi

Without any formula:
Enter 1st date into A1
Select the range A1:A200
From Edit meni, select Fill>Series, set Date Unit to Month, and click OK

With formula:
Enter 1st date into A1
Into A2, enter the formula
=DATE(YEAR(A1),MONTH(A1)+1,1)
, and format it as date.
Copy A2 down until to A200.


Arvi Laanemets
 
Back
Top