# Thread: increment month (97 sr2)

1. ## increment month (97 sr2)

I want user to enter one date only, and from this date the next 11 cells are updated to incremented months/year.
i.e. user enters 01/05/2003 in cell C4 and cells C5 to C16 are automatically updated with 01/06/2003 to 01/04/2004.

Currently I am using this concatenation formula (this is in C5):
=IF(MONTH(C4)<9,"01/0","01/")&IF(MONTH(C4)=12,"01",MONTH(C4)+1)&"/" & IF(MONTH(C4)=12,YEAR(C4)+1,YEAR(C4))
and then this formula in D5:
=C5+MONTH(N(C5))
The cells in column D incidentally are formatted for MMM-yy
Is there a simpler way or am I just imagining it.
TIA
Alan,
Cheshire

2. ## Re: increment month (97 sr2)

You could try this in C5. You can copy this formula for the rest of the dates.
=DATE(YEAR(C4),MONTH(C4)+1,1)

3. ## Re: increment month (97 sr2)

Thanks Tony,
I knew it was there somewhere.
Alan

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•