Counting a day of the week

[Guest]

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.

 

[N Harkawat]

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

 

[Ron Rosenfeld]

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

 

[Gnasher]

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!