This is a real problem, and it deserves a real solution, not another workaround. The user who posted this is doing meaningful work, calculating program hours for a treatment center, and they hit a wall with Excel. That wall is not their fault. It is the fault of a tool that was designed for ledgers, not for logic that changes with the day of the week.
Here is what we think: the approach should be simpler than most tutorials suggest. The user needs to count the number of Mondays through Thursdays between two dates, multiply that by five hours, then count the Fridays and multiply by three hours. That is the core. No pivot tables. No nested IFs that collapse under their own weight. A clean, readable formula using NETWORKDAYS.INTL and a custom weekend parameter can isolate each day type. Drop-down menus for the start and end dates make it repeatable without editing the formula each time. The user is already in the weeds; they need a path out, not a deeper dive.
What this means in practical terms is that the user can stop wrestling with Excel's calendar functions and start focusing on what matters: accurate program hours for the people they serve. The fix is not about learning more functions. It is about choosing the right function for the right job. NETWORKDAYS.INTL accepts a string of seven digits (1 for day off, 0 for workday) so you can define Monday through Thursday as workdays, Friday as a workday, and Saturday and Sunday as days off, then handle Friday separately with a second formula. Combine the two results, and the total appears. A date validation drop-down ensures the inputs are clean.
The real lesson here is that spreadsheets should adapt to the user, not the other way around. The user already knows their schedule. They should not have to contort Excel into understanding it. This is exactly the kind of friction that an AI-native approach eliminates: you describe the rule, and the system applies it. But even without that, a smarter formula design gets the job done today. The user asked for help, and the answer is not a bigger spreadsheet. It is a more honest one.