Date 13 Weeks from now
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
|