View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_12_] John[_12_] is offline
external usenet poster
 
Posts: 1
Default Calculating number of weeks between dates?

Hi. Does anyone know how I can calculate the number of whole weeks
between two dates?

E.g. I have 09/07/2007 in cell B10.
In cell B11 01/12/2007.

Is there a formula I can use to calculate the number of saturdays
between those two dates?

If I do B11-B10 I get the result 22/05/1900.

Cheers for your help

John