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
You are viewing 1 out of 4 answers, click here to view all answers.