Learn how to calculate the time between two dates and subtracting holidays in Excel, using this simple working days formula.
A specific Excel formula exists that allows us to calculate the days that have passed between two dates, excluding festivals and bank holidays. The formula is called NETWORKDAYS:
NETWORKDAYS(initial date;final date; holidays)
Using the formula is simple. First input the initial date followed by the end date and finally t all the holiday dates:
If there are several days, you can select them like any other camp.
|2||10/01/2008||Start date for a project|
|3||3/01/2009||End date for a project|
|=NETWROKDAYS(A2;A3)||Working days between initial and final date|
|=NETWROKDAYS(A2;A3;A4)||Working days between initial and final dates, excluding the first day of holiday|
|=NETWROKDAYS(A2;A3;A4:A6)||Working days between initial and final dates, excluding all days of holiday|