=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