Try this:

With
A1: (the start date)
B1: (the end date)

This formula counts the number of Saturdays within that date range
C1: =SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,A1):INDEX(A:A,B1)))=7))

Note: 1=Sunday, 2=Monday.....7=Saturday

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paulf" wrote:

Hiya

Is there a way of calculating the number of Saturdays between two dates in
Excel?

Thanks in advance
Paul