Number of working days in a month
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?
qdirector 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.
qdirector Selected answer as best