View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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