Excel practice · Dates & Arrays

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

  1. Build a hire date from Year/Month/Day
  2. Find transit time between two dates
  3. Count whole months a subscription has run
  4. Calculate an employee's tenure in full years
  5. Build a live countdown to a deadline

The exercises

1. Build a hire date from Year/Month/Day Medium

An HR export splits the hire date into separate Year, Month, and Day columns. Put it back together as one usable date.

ABCDE
1EmployeeYearMonthDayHire date
2Lena Ortiz2026315?

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.

2. Find transit time between two dates Medium

A shipment left the warehouse on one date and arrived on another. Find out how many days transit took.

ABCD
1ShipmentShip dateArrival dateTransit days
2Order #44712026-02-012026-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.

3. Count whole months a subscription has run Medium

A subscription started on one date. Find how many whole months it has been active as of the renewal-check date.

ABCD
1CustomerStart dateCheck dateMonths active
2Priya N.2025-11-102026-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.

4. Calculate an employee's tenure in full years Medium

HR wants each employee's tenure in full years as of the review cycle-end date, for a length-of-service bonus.

ABCD
1EmployeeHire dateReview dateFull years
2Marcus T.2019-03-102026-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.

5. Build a live countdown to a deadline Hard

Finance wants a countdown to the fiscal year-end close that stays correct every time the sheet is opened, with no manual updating.

AB
1DeadlineDays remaining
22026-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 →

More dates & arrays practice

All Excel practice exercises · Excel test prep