Excel: Calculate No of Days on Weekday Only

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.

Problems:

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.

 

Solutions:

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.

YLNotes_Excel_CalculateDaysOnWeekdayOnly_0001

 

Downloads:

  1. Download YLNotes_Excel_CalculateDaysOnWeekdayOnly.xlsx (36)

 

Forums:

  1. TechNet: Date Calculation – weekdays only

 

References:

  1. Microsoft: IS Functions

 

Leave a Reply

Your email address will not be published. Required fields are marked *

two × 3 =

YLNotes: Yunlong Notes © 2017 Frontier Theme