Excel Tutorial – NETWORKDAY

The NETWORKDAY function in Microsoft Excel is a useful tool for calculating the number of workdays between two dates. This can be helpful for tasks such as scheduling projects or calculating deadlines.

Here’s how to use the NETWORKDAY function:

1. Open a blank Excel spreadsheet.
2. In the cell where you want to display the result of the NETWORKDAY function, type the following formula: =NETWORKDAYS(start_date, end_date, [holidays])
3. Replace “start_date” with the cell reference or date value for the start date. For example, if the start date is in cell A1, you would enter A1 in place of “start_date”.
4. Replace “end_date” with the cell reference or date value for the end date. For example, if the end date is in cell A2, you would enter A2 in place of “end_date”.
5. Optionally, you can include a list of holidays in the formula by replacing [holidays] with a cell range or array of dates. For example, if you have a list of holidays in cells A3:A10, you would enter A3:A10 in place of [holidays]. If you don’t include a list of holidays, the NETWORKDAY function will assume that all weekends are non-working days.
6. Press Enter to calculate the result. The result will be the number of workdays between the start date and end date, excluding any holidays that you specified.

For example, let’s say you have a project that needs to be completed within 10 workdays. You can use the NETWORKDAY function to determine the end date for the project by starting with the current date and adding 10 workdays. Here’s how the formula would look:

=NETWORKDAYS(TODAY(), TODAY()+10, A3:A10)

This formula would use the TODAY function to get the current date, and then add 10 workdays to it. The list of holidays in cells A3:A10 would be excluded from the calculation.