Chapter 6 Working with dates ・ MISSION 26

Mission 26: Day of the week

📋 Mission list

Task

In B2:B5, show the day of the week of each date (Monday, Tuesday…).

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 26

Day of the week

In B2:B5, show the day of the week of each date (Monday, Tuesday…).

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =TEXT(A2,"dddd")

TEXT(A2,"dddd") turns the day of the week into text. Unlike changing the cell format, you can join the result with & or count it with COUNTIF.

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