# Calculate Working Days Between Two Dates

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:

`NETWORKDAYS(10/01/2008;10/04/2009;11/26/2008)`

If there are several days, you can select them like any other camp.

AB
1DateDescription
210/01/2008Start date for a project
33/01/2009End date for a project
411/26/2008Holiday
512/4/2008Holiday
61/21/2009Holiday
Formula
=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