View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fish
 
Posts: n/a
Default Function to calculate the nuber of weeks between dates?

What would the function (if any) be to calculate the number of weeks between
two dates.

Someone helped me with a function that calculates the number of days as:

=DATEDIF(B2,X2,"d")

I tried simply changing the "d" to "w" in hopes the d was short for days and
W would be short for weeks, but it didn't work.

I'm new to Excel and using Excel 2002. Is there a function that can
calculate the number of weeks between two dates?

Thanks.