How to find the number of Fridays in a month
Posted by Dale Yehle on December 26, 2001 7:21 PM
I am working on a spreadsheet and I would like to know if there is a fast or easy way to find the total number of Fridays in a given month. I can get the first Friday, but need to know if it is 4 or 5 in that particular month.
Posted by Derek on December 26, 2001 9:13 PM
A1 enter date of first day
B1 enter date of last day
C1 enter formula:
=IF((B1-A1)+1+WEEKDAY(A1,1)=35,5,4)
Posted by Derek on December 26, 2001 10:05 PM
Sorry Dale, my formula is in error. This one seems to work okay though
A1 Insert date of first day (of month)
B1 Insert date of last day (of that month)
C1 Insert formula:
=IF(WEEKDAY(A1,1)=7,4,IF((B1-A1)+1+WEEKDAY(A1,1)>=35,5,4))
