Formulas to calculate the number of weekdays, Saturdays, and Sundays between two dates
I have three columns: Weekdays, Saturdays, and Sundays.
I need to calculate the quantity of each of these three types of days based on start and end dates. The NETWEEKDAY and NETWEEKDAYS functions do not work in this case because the start and end dates should be included in the count.
Example: Start date of 8/22/2021 and end date of 8/28/21 should return a value of "5" in the Weekdays column, "1" in the Saturdays column, and "1" in the Sundays column.
Help Article Resources
Check out the Formula Handbook template!