I'm building a forecast for a company that pays employees every 10th and 25th of the month. The pay period starts on the 8th and the 23rd of every month and ends on the 7th and 22nd of every month. Employees work 8 hours a day, but they only work on weekdays. Based on these constraints sometimes the days an employee needs to be paid for during a period can range wildly based on where weekends fall and the month (sometimes 13 days, 14, 15, 16, etc).
I've ran into similiar problems like this before. How can I set up the file in a way where I can count just the cells I want to count based on where the "breaks" are from one period to a new period?
In the attached example I've setup the problem with a manual plugged solution in column H. Appreciate any help on how to solve this problem. I can't use macros for the solution. Thank you!
Bookmarks