|
|
|
|
|
Calculate workdays between dates using Excel
We're going to calculate how many workdays, considering the holidays, are there between two specific dates
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
Start the Microsoft Excel and enter the the data just like I did.
|
|
| |
2.
|
|
|
Click the cell next to Working days.
|
|
| |
3.
|
|
|
In the menu click Formulas.
|
|
| |
4.
|
|
|
And click the Insert Function button.
|
|
| |
5.
|
|
|
Select All for the category, choose the NETWORKDAYS function and click GO.
|
|
| |
6.
|
|
|
In the new window click Start_date field and the click the cell where you have your project start date, click End_date and click the cell with your end date.
|
|
| |
7.
|
|
|
Click the Holidays field ...
|
|
| |
8.
|
|
|
... and select the cells with holiday entries.
Click OK.
|
|
| |
9.
|
|
|
And there's your result. Shouldn't be to hard to finish your project in time ;)
|
|
|
 |
|
|
|
