Chapter 6 Working with dates ・ MISSION 23
Mission 23: Renewal date one year later
Task
In B2:B5, show the date exactly 12 months after each contract date.
B2fx
A
B
1
Contract date
Renewal date
2
4/1/2025
3
10/31/2025
4
2/29/2024
5
6/15/2025
6
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 23
Renewal date one year later
In B2:B5, show the date exactly 12 months after each contract date.
A
B
1
Contract date
Renewal date
2
4/1/2025
3
10/31/2025
4
2/29/2024
5
6/15/2025
6
A
B
1
Contract date
Renewal date
2
4/1/2025
4/1/2026
3
10/31/2025
10/31/2026
4
2/29/2024
2/28/2025
5
6/15/2025
6/15/2026
6
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =EDATE(A2,12)
EDATE moves a date by whole months. When the same day does not exist, as with 12 months after Feb 29, it uses the last day of the month. Adding 365 is off in leap years.
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).