This function returns the number of work days between the given dates.
NetWorkDays([StartDate],[EndDate],[Holidays])
StartDate is the date to start counting the work days from.
EndDate is the date to count the work days to.
Holidays are the dates to exclude from the returned number of work days.
Dates can be specified as text strings, e.g. "10/08/2010". They are converted to dates using the system regional settings. On a US system "10/08/2010" would result in the 8th of October, however, on a UK system, the same string will result in the 10th of August.
When creating projects that work in countries with different regional settings, it's recommended to use the format "YYYY-MM-DD", e.g. "2010-08-10". Dates in this form will always be understood the same way on all systems.
| 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 |