How to calculate the number of specific weekdays in a month

**rowlandrat** · 05-10-2011, 07:45 AM

Hi,

I am trying to find out how many specific weekdays exist in a month. For example, I need to know how many Mondays in a particular month.

I know how to get the working days in a month using the networkdays formula but is there any way then to link that to another formula which gives you a break down of the number of specific days e.g.

May has 22 work days, 5 Mondays, 5 Tuesdays, 4 Wednesdays, 4 Thursdays and 4 Fridays

Thanks

**NBVC** · 05-10-2011, 07:53 AM

With A1 containing a date, try:

Please Login or Register  to view this content.

This finds # of Mondays in the month of the date you entered.

Change the 1 to 2 for Tuesday, 3 for Wednesday, etc...

**arthurbr** · 05-10-2011, 07:56 AM

An array formula (commit with Ctrl+Shift+enter)

Please Login or Register  to view this content.

This formula assumes the following:
A2 contains the beginning date of the interval
B2 contains the ending date of the interval
C2 contains the day-of-week number (1=Sunday, 2=Monday,...,7=Saturday)

**Whizbang** · 05-10-2011, 09:58 AM

There is also a function called NETWORKDAYS()

I think you need to have the analysis toolpak installed for this, though.

Anyway, the syntax is

=NETWORKDAYS(Start_Date,End_Date,[Holidays])

**Edit**
Oh. Nevermind. I read the original post again, this time with my eyes open, and realized what you were asking. NETWORKDAYS will give you the total count of workdays, but not specific days.