Dates Adding 9 months to 1/1/09

[Kathleen]

Hi,

Is it possible to create a formula that will add a specific number of months
to a date?

Column a1 has the begin date 1/1/09
Column b1 needs to show 9 months from 1/1/09, which would give an end date
of 10/1/09

Kathleen

 

[macropod]

Hi Kathleen,

For a date in A1:
=MIN(DATE(YEAR(A1),MONTH(A1)+9+{0,1},DAY(A1)*{1,0}))
This ensures adding 9 months to the 31st of the month, for example, won't spill over to the next month.

 

[Kathleen]

That works perfectly! Thank you!!

Hi Kathleen,

For a date in A1:
=MIN(DATE(YEAR(A1),MONTH(A1)+9+{0,1},DAY(A1)*{1,0}))
This ensures adding 9 months to the 31st of the month, for example, won't spill over to the next month.

--
Cheers
macropod
[Microsoft MVP - Word]

Hi,

Is it possible to create a formula that will add a specific number of months
to a date?

Column a1 has the begin date 1/1/09
Column b1 needs to show 9 months from 1/1/09, which would give an end date
of 10/1/09

Kathleen