Number of working days in a month

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Solved2.80K viewsFormulas and Functions

I am trying to create a formula that shows the number of working days in a month (i.e. the number of Mondays Tuesdays Wednesdays Thursdays and Fridays in a particular month).

Any suggestions on how to proceed?

Selected answer as best

Hi all,

This is another solution model of the author’s problem. The model is quite simple and universal. The model consists of three steps:
1. Ask the inclusive date interval. You may input any date period.
2. One simple formula counts how many Mo, Tu, We, Th, Fr, Sa and Su are between two dates.
3. The particular answer to the author’s problem. Another simple formula counts the number of working days in the date interval.

Selected answer as best

No, I wasn’t at the QM seminar last month. And I’m glad I was able to help you.


Thanks to both of you! I really appreciate your help. I’m sure other people will also, because I can’t be the first person to be needing this information.

SAU, were you at the Quantrix seminar last month?


Attached is a solution for you. I’d suggest that you incorporate some sort of DateDimension table if you have one from a Database. I’ve done this in the DateDim matrix on the accompanying file. You can then created a DataLink from this to populate categories for month, year, days. After that it is a count using as referencing the DateDimension Matrix.

Let me know if you have questions. I’ll try to make a video of this soon, and post the link to the video.


Rich Lopez