Date 13 Weeks from now

C

Craig

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
 
R

RagDyeR

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!
=====================================================

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
 
B

bpeltzer

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

Ron Rosenfeld

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
Click to expand...

With date in A1:

=A1+91

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


--ron
 
Top