For the accountants, calculating the number of working days, the number of working days of employees is a time-consuming task. Instead of using manual methods like counting hands to calculate the number of working days. Excel gives you a NETWORKDAYS function that calculates the number of full-time workdays between two dates accurately and quickly.
Syntax: =NETWORKDAYS (start_date, end_date, [holidays])
The NETWORKDAYS function syntax has the following arguments:
- start_date – This is the start date that you wish to use in the calculation. This value should be entered as serial date always, not a text date.
- end_date – This is the end date that you wish to use in the calculation. This value should be entered as a serial date always, not a text date.
- holidays – This is optional in the syntax of the function. This is the list of total holidays to be excluded from the workday calculation. You can enter this option as a range of cells that contains the holiday dates (i.e. F2:F5) or as the list of serial numbers that are already representing the holiday dates.
Note: Weekend – specifies which weekdays should be counted as weekend days. This can be either a number or a string, as demonstrated below.
|1 or omitted||Saturday, Sunday|
Example: Let’s look at some Excel NETWORKDAYS function examples and explore how to use the NETWORKDAYS function as a worksheet function in Microsoft Excel: