Excel date functions (DATE, TODAY, DATEDIF) practice exercises
5 graded problems with realistic data, from medium to hard.
DATE, DATEDIF, DAYS, and TODAY: building, measuring, and comparing dates. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the Date functions (DATE, TODAY, DATEDIF) guide first: syntax, a worked example and the mistakes people make.
In this set
- Build a hire date from Year/Month/Day
- Find transit time between two dates
- Count whole months a subscription has run
- Calculate an employee's tenure in full years
- Build a live countdown to a deadline
The exercises
An HR export splits the hire date into separate Year, Month, and Day columns. Put it back together as one usable date.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Employee | Year | Month | Day | Hire date |
| 2 | Lena Ortiz | 2026 | 3 | 15 | ? |
Enter a formula in E2.
Show a hint
DATE takes year, month, day as three separate arguments: =DATE(B2,C2,D2).
Real HR and finance exports often split a date across separate Year/Month/Day columns. DATE puts it back together into one date value you can actually sort, filter, or do math on.
A shipment left the warehouse on one date and arrived on another. Find out how many days transit took.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Shipment | Ship date | Arrival date | Transit days |
| 2 | Order #4471 | 2026-02-01 | 2026-02-09 | ? |
Enter a formula in D2.
Show a hint
DAYS takes the end date first, then the start date: =DAYS(C2,B2).
DAYS is the quick way to measure the gap between two dates without doing manual date math, whether that's transit time, turnaround time, or days since last contact.
A subscription started on one date. Find how many whole months it has been active as of the renewal-check date.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Customer | Start date | Check date | Months active |
| 2 | Priya N. | 2025-11-10 | 2026-09-10 | ? |
Enter a formula in D2.
Show a hint
DATEDIF with the "m" unit counts whole months between two dates: =DATEDIF(B2,C2,"m").
DATEDIF is the one function built to speak directly in "whole years/months/days between two dates." That's exactly what subscription, tenure, and aging reports need.
HR wants each employee's tenure in full years as of the review cycle-end date, for a length-of-service bonus.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Employee | Hire date | Review date | Full years |
| 2 | Marcus T. | 2019-03-10 | 2026-03-01 | ? |
Enter a formula in D2.
Show a hint
DATEDIF with the "y" unit counts full years, even when this year's anniversary hasn't quite arrived yet: =DATEDIF(B2,C2,"y").
"y" is DATEDIF's most common unit in real HR and finance reporting, used for tenure, age, or years since launch. It correctly holds back a year until the anniversary date actually passes.
Finance wants a countdown to the fiscal year-end close that stays correct every time the sheet is opened, with no manual updating.
| A | B | |
|---|---|---|
| 1 | Deadline | Days remaining |
| 2 | 2026-12-31 | ? |
Enter a formula in B2.
Show a hint
DAYS works with TODAY() as one of its dates too. It always uses whatever "today" is when the formula runs: =DAYS(A2,TODAY()).
A countdown that's correct today and still correct next month is exactly what TODAY() is for. It recalculates fresh every time the sheet opens, no manual updates needed. LearnExcel checks this one live, the same way, so the right answer always matches whatever day you're solving it on.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the Date functions (DATE, TODAY, DATEDIF) exercises →