Counting a day of the week
 

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.

=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.

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

In article ,
says...
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.

=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)

seems to work!