DriveWorks Solo 15: NetworkDays [send feedback...]

NetWorkDays

This function returns the number of work days between the given dates

Syntax

NETWORKDAYS([StartDate],[EndDate],[Holidays])

StartDate is the date to start counting the work days from. Date format must be month/date/year.

EndDate is the date to count the work days to. Date format must be month/date/year.

Holidays are the dates to exclude from the returned number of work days.. Date format must be month/date/year.

Examples

Rule

Meaning
NETWORKDAYS("10/08/2010","10/30/2010","10/12/2010")This will count all the work days in between 10/08/2010 and 10/30/2010, but exclude the day of 10/12/2010 and will return 15
NETWORKDAYS("10/08/2010","10/30/2010","10/12/2010","10/13/2010")This will count all the work days in between 10/08/2010 and 10/30/2010, but exclude the days of 10/12/2010 and 10/13/2010 and will return 14

Table of Contents