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

Calculating number of weeks between dates?
 

One way

=SUM(INT((WEEKDAY(B10-7)+B11-B10)/7))



--


Regards,


Peo Sjoblom


"John" wrote in message
...
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

Calculating number of weeks between dates?
 

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(B10&":"&B11)))=7))


"John" wrote:

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