Thread
:
calculating number of months from today
View Single Post
#
5
Don Guillett
Posts: n/a
try
=DATE(YEAR(D4),MONTH(D4)+10,DAY(D4))
=DATE(YEAR(TODAY()),MONTH(TODAY())+13,DAY(TODAY()) )
--
Don Guillett
SalesAid Software
"JNW" wrote in message
...
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.
Reply With Quote