The NETWORKDAYS (TOTALWORKDAYS) function in Excel can be used to compute the number of working days in a particular period, that is, the number of days that exist from one date to the next, excluding weekends. It allows you to perform an accurate computation, including excluding any holidays that may exist. Learn how to reproduce this command in your file by following the steps outlined below.
Before I show you how to use the NETWORKDAYS calculation in Excel, make sure your spreadsheet has all of the necessary information. They are the start date of the interval to be evaluated, the end date of that period, and, if applicable, the dates of any holidays that occur during that period.
Each of these pieces of information must be entered into a separate worksheet cell and formatted as follows: DAY/MONTH/YEAR, with the full year and no abbreviations. In addition, if the examined period includes more than one holiday, each of these dates must be entered into a separate cell.
How to calculate working days
Check out how to calculate the working days of a particular period in Excel, first without taking into account your vacations:
Select the cell and type the following formula: Paste the formula =TOTALWORKDAYS (A2; A3) into the cell where the final calculation should appear. The value A2 replaces the position of the cell containing the start of the studied period, while the value A3 replaces the location of the cell containing the end of the examined period in this formula.
Change the number: Replace the value A2 in the formula =NETWORKDAYS(A2, A3) with the cell containing the range’s start date. The date 10/04/2021 appears on A4 in our example. The value A3 must be replaced by the cell containing the range’s end date. In our example, the date is 12/04/2021, which is in B4. As a result, the formula should be: = NETWORKDAYS(A4; B4);
Enter: When you’re finished, press Enter to see the proper number appear. It will be 45 in this situation, because that is the number of working days between April 10 and April 12, 2021, not including holidays.
How do you add up working days and holidays?
- If you wish to know the number of working days in the period, omitting holidays, paste the formula =TOTALWORKDAYS(A2;A3;A4:A6) in the cell where the final calculation should appear, where A4 and A6 replace the row and column locations of cells holding holiday dates.
It’s worth noting that, unlike semicolons, colons are used to separate the start and end dates of the assessed period. There are just two values for holidays in the formula, but you can add as many as you need (always separating them with a colon) based on the number of cells with holidays.
- Replace the values with the cells at the beginning of the evaluated period, the end of the evaluated period, and holidays from your spreadsheet after pasting the formula. For our example, the formula should be: =TOTALWORKDAYS (A4;B4;C2:C3).
- When you press the Enter key, the proper number appears. In the example, it will be 43, because it is the number of working days between April 10th and April 12th, taking into account the holidays in between.
This information was first published on nyscinfo.com. DMCA PROTECTED.