Use the DateAdd function:

newDate = DateAdd("m", 3, oldDate)

This adds three months to oldDate and assigns it to newDate.

Regards,
Steve

kicek schrieb:

Dear all,

I have following problem with excel. I have date for example 12-04-2006
and i need to do next dates.
I know that the date will be 3 mounth later ( this same day )
12-07-2006 and 12-10-2006 and 12-01-2007 etc etc. How to generate this
dates becouse this is very difficult to include by hand ( i have 12,5
thausend records ) and transactions for 10 years. ( 40 dates for one
record )

:((((


Thank you for your help


Best regards
Jarek Krolikowski