Date values

Posted by wendy on August 30, 2001 6:53 AM

What formula can I use to caluclate a series of dates in a column such that each date is one month different, but the same date in the month. For example, January 10, 2001, February 10, 2001, etc.?

Posted by Barrie Davidson on August 30, 2001 7:05 AM

Assuming your start date is in cell A1,

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

Regards,
Barrie

Posted by Aladin Akyurek on August 30, 2001 7:06 AM

=EDATE(A1,1)

You need to have Analysis Toolpak (if not already the case), which you can add via Tools|Add-ins.

Aladin