NETWORKDAYS(start_date, end_date [,holidays]) |
Returns the total number of working days between two dates excluding weekends and holidays. |
start_date | The starting date. |
end_date | The finishing date. |
holidays | (Optional) An array of dates to exclude. |
Remarks |
* NETWORKDAYS.INTL was added in Excel 2010 to replace this function. * This function excludes weekends and any other dates specified in the "holidays" array. * This function has an explicit assumption that weekends are Saturday and Sunday. The NETWORKDAYS.INTL allows you to specify what days you want to treat as weekends. * Both the "start_date" and the "end_date" are included in the total count. * If "start_date" is not a valid date, then #VALUE! is returned. * If "end_date" is not a valid date, then #VALUE! is returned. * If "holidays" is left blank, then only weekends will be excluded. * The "holidays" allows you to specify bank holidays as well as any other floating holidays. * The "holidays" can either be range of cells containing dates or an array constant of serial numbers. * If "holidays" contains anything that is not a valid date, then #NUM! is returned. * You can use the WORKDAY to return the serial number that is a given number of working days before or after a date. * You can use the NETWORKDAYSMISC - User Defined Function to return the number of days between two dates using a defined list of workdays. * For the Microsoft documentation refer to support.office.com |
|
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top