NETWORKDAYS |
NETWORKDAYS(start_date, end_date [,holidays]) |
Returns the number of working days between two dates excluding weekends and holidays. |
start_date | The starting date. |
end_date | The finishing date. |
holidays | (Optional) The dates to exclude from the working calendar, holidays and floating days. |
REMARKS |
* NETWORKDAYS.INTL was added in Excel 2010 to replace this function and to let you choose what days you want to treat as weekends. * This function should be pronounced NET workdays. * This function can be used to calculate the total days (given a start date and end date). * This function has an explicit assumption that weekends are Saturday and Sunday. * This function will always exclude weekends but can also exclude any other dates specified in the "holidays" array. * 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 a range of cells containing dates or an array constant of serial numbers. * If "holidays" contains anything that is not a valid date, then #VALUE! is returned. * You can use the DATE function to return the date as a date serial number given a year, month, day. * You can use the DATEVALUE function to return the date serial number given a date in text format. * You can use the DAYS function to return the number of days between two dates. * You can use the DAYS360 function to return the number of days between two dates, based on 30 day months. * You can use the NETWORKDAYS.INTL to return the number of working days between two dates excluding weekends and holidays. * You can use the WORKDAY function to return the date serial number that is a given number of working days before or after a date. * You can use the WORKDAY.INTL to return the date 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.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - Does "1 Jan 2021" fall on a workday or a weekend. This is a Friday. When the start date and end date are the same, this function returns 1 when it's a workday. 2 - How many working days between 1 Jan 2022 and 2 Jan 2022. These days were Saturday and Sunday, so zero. 3 - How many working days between 1 Jan 2022 and 3 Jan 2022. These days were Saturday, Sunday and Monday, so one. 4 - How many working days between 1 Jan 2022 and 9 Jan 2022. Two of these days are Saturday and two are Sunday, so 9 - 4 = 5 5 - How many working days between 1 Jan 2022 and 4 Jan 2022. The 1 Jan is Saturday and 2 Jan is Sunday and since the 3 Jan is a holiday the only workday is 4 Jan. 6 - How many working days between 1 Jan 2022 and 4 Jan 2022. The 1 Jan is Saturday and 2 Jan is Sunday and since both 3 Jan and 4 Jan are holidays there are no working days. 7 - How many working days between 1 Jan 2022 and 1 Feb 2022. 8 - How many working days between 30 Jan 2022 and 2 Feb 2022. There are 31 days in January but 30 Jan 2022 is Sunday. 9 - How many working days between 31 Jan 2022 and 2 Feb 2022. 10 - This is the same as Example 4 using the DATE function. 11 - How many working days between 14 Jan 2022 and 1 Jan 2022. The start date is before the end date. 12 - How many working days between 1 Jan 2022 and 9 Jan 2022. Two additional holidays have been provided which fall on a Monday and a Tuesday, so 5 - 2 = 3 13 - How many working days between 1/1/2022 and 31/12/2022. These are not recognised dates and are just very small values. 14 - If the start_date or end_date are not valid dates, then #VALUE! is returned. 15 - If the holidays does not contain valid dates, then #VALUE! is returned. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top