Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 6/6

NETWORKDAYS: working days

Exercise 1 of 3

In C2, count the working days (Monday to Friday) from start to end.

About this lesson

NETWORKDAYS counts the working days between two dates, leaving out weekends and holidays.

In this lesson

  1. In C2, count the working days (Monday to Friday) from start to end.
  2. Two days in E2:E3 are holidays. In C2, count the working days without them.
  3. Does NETWORKDAYS count the start and end dates?

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in C2 and press Enter to check.