Excel problem :(
 

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

Excel problem :(
 

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

Excel problem :(
 

One way:

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

In article .com,
"kicek" wrote:

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 )

Excel problem :(
 

Thank You very much


JE McGimpsey napisal(a):
One way:

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