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

NetWorkDaysCustom

This function returns the number of work days between the given dates, allowances for which days are weekend days and holidays are

Syntax

NETWORKDAYSCUSTOM([StartDate],[EndDate],[WeekendValue],[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.

WeekendValue is a number (from the chart below) that represents the days to count as weekend days

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

Weekend Value

Weekend Days
1 or OmittedSaturday, Sunday
2Sunday, Monday
3Monday, Tuesday
4Tuesday, Wednesday
5Wednesday, Thursday
6Thursday, Friday
7Friday, Saturday
11Sunday only
12Monday only
13Tuesday only
14Wednesday only
15Thursday only
16Friday only
17Saturday only

Holidays

Examples

Rule

Meaning
NETWORKDAYSCUSTOM("10/08/2010","10/30/2010",3,"10/12/2010")This will count all the work days in between 10/08/2010 and 10/30/2010, taking Monday and Tuesdays as weekend days (3), but exclude the day of 10/12/2010 and will return 17

Table of Contents