=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" <[email protected]> wrote in message
news:[email protected]...
>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.
Bookmarks