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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello,

I have a date in in one cell, eg 22/04/08 and I want the next cells to be
one month higher, ie 22/05/08 , 22/06/08 etc etc. The number of days in a
month varies so I cant just add 30.

Can anyone help & advise please

Thanks

KK