Calculating number of weeks between dates?

[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

 

[Peo Sjoblom]

One way

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



--


Regards,


Peo Sjoblom

 

[Teethless mama]

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