Calculating number of weeks between dates?

J

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating number of weeks between two set dates 2
Calculating number of workdays between 2 dates 14
Calculate elapsed time excluding specific timeframe 10
Average days between dates 3
calculating number of weeks between two dates 4
count the number of months between two dates 3
Can you calculate the number of years between two dates in Excel 0 4
Function to calculate the nuber of weeks between dates? 4

Top