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.