View Single Post
  #3   Report Post  
David Billigmeier
 
Posts: n/a
Default

Assume your date is in A1 and you want to calculate 10 months from it:

=DATE(YEAR(A1),MONTH(A1)+10,DAY(A1))

--
Regards,
Dave
<!--


"JNW" wrote:

I work in a reservations department that has certain booking windows. I have
easily created the functions for counting days from today (i.e. =today() +
15) but I can't seem to find the means to count 10 and 13 months from today.

If today is 9/14/2005, then 10 months from now is 7/14/2006, and 13 months
is 10/14/2006.

Your helps is appreciated.