How to calculate a future date?

[ajhellman]

Hi,


I'm struggling with a formula to do the following:


Takes a # of months and adds it to today's date, to get a future date.


So, column A might have your months (such as 8 months for example), and I want column B to output today's date + the 8 months, so 7/17/2011. I'm not really sure how to do that....Any suggestions?


Thanks,

Adam

 

[keymaster]

@Adam.. use EDATE()


=edate(today(),8) to get the date 8 months from now.

 

[ajhellman]

Enlightening! Thank you for the quick reply!


Adam