Excel problem :(

[kicek]

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

 

[wisccal]

Use the DateAdd function:

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

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

Regards,
Steve

 

[JE McGimpsey]

One way:

A1: 12-04-2006
A2: =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))

 

[kicek]

Thank You very much


JE McGimpsey napisal(a):