# 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.

A B
1 Date Description
2 10/01/2008 Start date for a project
3 3/01/2009 End date for a project
4 11/26/2008 Holiday
5 12/4/2008 Holiday
6 1/21/2009 Holiday
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