Is there a function in Excel that will tell me what the date is 13
weeks from now ? So if I give it the initial date of 7/10/2006 13
weeks from now would be 10/9/2006.

Thanks,
Craig

13 weeks is 91 days, so with 7/10/06 in A1, try this:

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

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Craig" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
Is there a function in Excel that will tell me what the date is 13
weeks from now ? So if I give it the initial date of 7/10/2006 13
weeks from now would be 10/9/2006.

Thanks,
Craig

If the date is in A1, =A1+91. Or just =today()+91. Either way, format the
result as a date.

"Craig" wrote:

> Is there a function in Excel that will tell me what the date is 13
> weeks from now ? So if I give it the initial date of 7/10/2006 13
> weeks from now would be 10/9/2006.
>
> Thanks,
> Craig
>
>

On 15 Jul 2006 12:47:47 -0700, "Craig" <(E-Mail Removed)> wrote:

>Is there a function in Excel that will tell me what the date is 13
>weeks from now ? So if I give it the initial date of 7/10/2006 13
>weeks from now would be 10/9/2006.
>
>Thanks,
>Craig

With date in A1:

=A1+91

(e.g. A1+(7*13)


--ron