calculating number of months from today

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.

if a date is in A1 then

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

will go forward 13 months
--
Gary''s Student


"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.

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.

Worked perfectly. Thanks to both of you.

"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.

try
=DATE(YEAR(D4),MONTH(D4)+10,DAY(D4))
=DATE(YEAR(TODAY()),MONTH(TODAY())+13,DAY(TODAY()))
--
Don Guillett
SalesAid Software
donaldb@281.com
"JNW" <JNW@discussions.microsoft.com> wrote in message
news:E986BCC5-0507-4C63-81A4-4D83739E0AE2@microsoft.com...
> 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.

Try the EDATE function =EDATE(TODAY(),13)

"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.