If you want to know the number of net working days between two dates, the NETWORKDAYS function will come in handy.
In this tutorial, I will show you how to use the NETWORKDAYS function in Google Sheets.
Table of Contents
NETWORKDAYS Syntax
The NETWORKDAYS function will provide the number of working days between two dates.
The syntax of this function is:
=NETWORKDAYS(start_date, end_date, [holidays])
- start_date – this is the start date that will be used to calculate the number of net working days
- end_date – this is the end date that will be used to calculate the number of net working dates
- holidays – this is an optional argument. You can put in a range or array that contains dates that will not be counted as net working days in the final result
Using the NETWORKDAYS Function
Here is an example of how NETWORKDAYS is used in a spreadsheet
The first formula in the spreadsheet is =NETWORKDAYS(A2, B2), This returns a final result of 10, because it is a period of 2 weeks for which there are 10 working days.
The second formula in the spreadsheet is =NETWORKDAYS(A3, B3, C3). This returns a final result of 9 because it skips the provided holiday. It is a period of 2 weeks, and there is one holiday, so 9 net working days.
Closing Thoughts
As you can see by now, this function is very easy to use. Just provide your start date, end date, and any holidays that you want to skip from calculating in your final result. Then the function will return the total number of working days not counting weekends or holidays.
More Google Sheets Tutorials:
How to Use the WORKDAY Function