I am trying to count the customized days between specific dates based on a drop down on a spreadsheet. The customized days include building closures. An example is I have a program starting in September. I need to know the week of September it begins (September 10, 2018) and the day of the week it is on (Mondays). The program ends in December (December 17, 2018). Our business has a total of 11 working Mondays in that time frame, but I want excel to calculate that for me. This would have to work no matter what the date range. Can you help?
Solved by S. H. in 11 mins