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" wrote in message
oups.com...
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" 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