How to add 6 months to a date?

[alaskanpilot]

Hi guys,

I need a formula that will add six months to a date, while keeping the day the same.

Lets say I have 10-15-11 entered in A1. I want A2 to show 4-15-12. It's important that the particular day stay the same, in this case it must be the 15th both times.

Thanks!

 

[barry houdini]

One way is to use EDATE, i.e.

=EDATE(A1,6)

 

[wigi]

for example:

=EDATE(A1,6)

 

[alaskanpilot]

Great! I new it had to be something simple, but I was not aware of the EDATE formula. Thanks so much!

 

[wigi]

Great! I new it had to be something simple, but I was not aware of the EDATE formula. Thanks so much!

You could have checked the list of available formulas. Clicking the Fx symbol in the formula bar is enough.

 

[Scott R]

Are you okay with 3/31/2012 becoming 9/30/2012?