Chapter 6 Working with dates ・ MISSION 24
Mission 24: Years of service
Task
In C2:C5, show the full years of service from the hire date to the reference date in F1.
C2fx
A
B
C
D
E
F
1
Name
Hire date
Years of service
Reference date
3/31/2026
2
Emma
4/1/2015
3
Olivia
10/1/2020
4
Liam
4/1/2025
5
Noah
4/1/2019
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 24
Years of service
In C2:C5, show the full years of service from the hire date to the reference date in F1.
A
B
C
D
E
F
1
Name
Hire date
Years of service
Reference date
3/31/2026
2
Emma
4/1/2015
3
Olivia
10/1/2020
4
Liam
4/1/2025
5
Noah
4/1/2019
6
A
B
C
D
E
F
1
Name
Hire date
Years of service
Reference date
3/31/2026
2
Emma
4/1/2015
10
3
Olivia
10/1/2020
5
4
Liam
4/1/2025
0
5
Noah
4/1/2019
6
6
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =DATEDIF(B2,$F$1,"Y")
In DATEDIF, "Y" gives full years and "M" full months. Lock a single cell (the reference date) with $ when every row points to it.
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).