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.

ExcelA 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


  • Was this Helpful ?
  • YesNo