There is a help request in TechNet Forums on how to calculate no of days on weekday only (i.e. excludes weekend days).
In discussion, there is an issue in Excel data cell that contains invalid date such as blank, empty space, or even formula with no visible data causes incorrect days calculation.
Calculate No of Days on Weekday Only using Excel that can handle invalid date data such as empty cell, space, or even formula with no visible data.
It is best to work out on Excel to find the best solution (get it at Downloads section below).
My preferred solution is Solution 1 using NetworkDays() with Empty Cell Fix.
- Download YLNotes_Excel_CalculateDaysOnWeekdayOnly.xlsx (181)