Chapter 6 Working with dates ・ MISSION 22

Mission 22: Month-end closing date

📋 Mission list

Task

In B2:B5, show the last day of the month of each invoice date.

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 startsWorking with dates

Chapter 6 ・ MISSION 22

Month-end closing date

In B2:B5, show the last day of the month of each invoice date.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =EOMONTH(A2,0)

EOMONTH returns the last day of a month: 0 for the same month, 1 for the end of next month (a common payment term). It handles February and 30-day months automatically.

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