View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default Subtracting dates into weeks...

=int(EndDate-StartDate)/7)

in your example the results is 183 weeks

HTH

"Lucy" wrote:

I need to subtract dates to give me how many weeks are in between to
specified dates?

e.g. 1/15/02 thru 7/21/05

Help?