Hi,

Enter start date into A1, then copy the following formula in A2 through A12:

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

Let me know if this helps.

Thanks,
Peggy

"¤§Tarzan§¤" wrote:

Hi all,

I'm trying to adjust a timeline by adjusting just the start date...can any
one please help me with a formula to do so (producing next month on the next
cell in reference to the previous month in the previous cell)?

eg
start date: Aug-07
Timeline: Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08.....

adjusted start date: Nov-07
Adjusted Timeline: Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08
Jun-08.....

Cheers,