Chapter 6 Working with dates ・ MISSION 25

Mission 25: Working days without holidays

📋 Mission list

Task

In D2:D4, show the working days from the start date to the end date (excluding weekends and the holidays in column F).

Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.

Chapter 6 ・ MISSION 25

Working days without holidays

In D2:D4, show the working days from the start date to the end date (excluding weekends and the holidays in column F).

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =NETWORKDAYS(B2,C2,$F$2:$F$5)

NETWORKDAYS counts the start and end dates too, and leaves out weekends and the listed holidays.

To practice one function at a time:Function drillExcel function list

* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).