Add Month to Date

[lesley burlingham]

I need to add a month to a date. The date in cell C2 is a formula. =Sheet2!C5

It reads the date from Sheet2.

 

[Khalid NGO]

Hi Lesly,
Not clear to me.

Can you specify more? or can you post a sample having expected results?

 

[lesley burlingham]

Sorry yeah sure. See attached

Date in sheet 1 D2 is taken from C5 on sheet 2

I need the list of dates in colum D to increment by 1 month on every row.

 

[Khalid NGO]

Try:
=DATE(RIGHT(D2,4),MID(D2,3,2)+ROW()-1,LEFT(D2,2))

Copy down.

if you want direct from sheet2, change "D2" to "Sheet2!$C$5"

Regards,

 

[lesley burlingham]

Thaks, The forumal isn't coping down correcly. It workson the firs row then doesrandom datas afte tha.

 

[NARAYANK991]

Hi Lesley ,

See if this works ; I have changed the value in the cell C5 on Sheet2 to a valid date.

Narayan

 

[Khalid NGO]

Thaks, The forumal isn't coping down correcly. It workson the firs row then doesrandom datas afte tha.

Hi,
Works fine at my end.

 

[lesley burlingham]

Wonderful thank you very much for your help