Excel & Sheets practice: Date Parts & Construction
Chapter 15 · 4 questions · included in full access
Question 1 · easy
Joining month label
Solve it in your browserShow each joining date as a label like
Jun 2021. Start in J2, fill to J13.Question 2 · medium
Weekend joiners
Solve it in your browserLabel each joining date
"Weekend"or"Weekday". Start in J2, fill to J13.Question 3 · hard
This year’s work anniversary
Solve it in your browserReturn each employee's work anniversary in the current year (same day and month as joining, year of TODAY()). Start in J2, fill to J13.
Question 4 · easy
Dates are numbers
Solve it in your browserA cell formatted as a date contains
=DATE(2026,1,31)+1. What does it show?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing