2 Months Date Return

[Cheri]

Could someone help me with a formula to return a date that is 2 months later
- Is there a formula for that i.e. 10/1/04 and 2 months would be 12/1/04
rather than adding 60 days. Make sense?

 

[Don Guillett]

this should work for your needs.
=DATE(YEAR(C17),MONTH(C17)+2,DAY(C17))

 

[Cheri]

Thank you! When I type accurately it works beautifully

 

[Don Guillett]

glad to help