On Wed, 25 May 2005 12:43:25 -0700, L_n_da
wrote:

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.


A1: Start Date
A2: End Date

=INT((A2-WEEKDAY(A2-5)-A1+8)/7)

In general:

=INT((A2-WEEKDAY(A2+1-DOW)-A1+8)/7)

where DOW is replaced by the Day of the Week where Sunday=1 and Saturday=7.




--ron