=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=6))
where cell a1 holds the date 6/14/05 and b1 holds 6/29/05

"L_n_da" wrote in message
...
I need to count the number of Fridays in a range of dates, e.g. how many
Fridays between 14 June 05 and 29 June 05 (including these two days). I'd
be
very grateful for your help.