YEAR, MONTH, WEEKDAY & NETWORKDAYS practice exercises
6 graded problems with realistic data, from easy to medium.
Pull a single piece out of a date, name which day of the week it falls on, or count the actual working days between two dates. The 6 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 YEAR, MONTH, WEEKDAY & NETWORKDAYS guide first: syntax, a worked example and the mistakes people make.
In this set
- Pull the year out of a date
- Pull the month out of a date
- Pull the day-of-month out of a date
- Find which day of the week a date falls on
- Find the day of the week, Monday-first
- Count working days between two dates
The exercises
Extract just the year from a hire date.
| A | B | |
|---|---|---|
| 1 | Hire date | 2026-03-15 |
| 2 | ? |
Enter a formula in A2.
Show a hint
YEAR(date) returns just the year as a number: =YEAR(B1).
Pulling the year out is the first step in almost any "group by year" report; a pivot table on a date column uses exactly this underneath.
Extract the month number from an order date, which sits in B2 here (row 1 is just the employee who placed it).
| A | B | |
|---|---|---|
| 1 | Employee | E-4821 |
| 2 | Order date | 2026-11-07 |
| 3 | ? |
Enter a formula in A3.
Show a hint
MONTH(date) returns 1 through 12: =MONTH(B2).
MONTH lets you group or filter dates by calendar position: every order in November, every invoice due this quarter, that sort of thing.
Extract the day-of-month number from an order date stored in C1 (column B just names the carrier).
| A | B | C | |
|---|---|---|---|
| 1 | Carrier | FedEx | 2026-11-07 |
| 2 | ? |
Enter a formula in A2.
Show a hint
DAY(date) returns just the day-of-month, 1 through 31: =DAY(C1).
DAY is the natural partner to YEAR and MONTH: together the three let a formula rebuild or compare any part of a date on its own.
Find the day-of-week number for October 3, 2026 (stored in D1, with the store name alongside it), using Excel's default numbering (1 = Sunday).
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Store | Downtown | Date | 2026-10-03 |
| 2 | ? |
Enter a formula in A2.
Show a hint
WEEKDAY(date) defaults to 1 = Sunday through 7 = Saturday: =WEEKDAY(D1).
WEEKDAY is how a formula can tell "is this a weekend?" or "is this a Monday?" without anyone reading a calendar.
Find the day-of-week number for October 3, 2026, but numbered so Monday = 1 and Sunday = 7 instead of Excel's default.
| A | B | |
|---|---|---|
| 1 | Date | 2026-10-03 |
| 2 | ? |
Enter a formula in A2.
Show a hint
WEEKDAY's 2nd argument changes the numbering, return_type 2 is Monday = 1: =WEEKDAY(B1,2).
Most of the world's calendars (and most companies' workweeks) start on Monday, not Sunday; this 2nd argument is how WEEKDAY matches that instead of Excel's US-centric default.
A project runs from Monday, October 5, 2026 through Friday, October 9, 2026. Count the number of working days (weekends excluded) in that span.
| A | B | |
|---|---|---|
| 1 | Start date | 2026-10-05 |
| 2 | End date | 2026-10-09 |
| 3 | ? |
Enter a formula in A3.
Show a hint
NETWORKDAYS(start, end) counts weekdays in the range, both ends included: =NETWORKDAYS(B1,B2).
NETWORKDAYS is the real formula behind "how many business days until this is due"; it skips Saturdays and Sundays automatically instead of making you count by hand.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the YEAR, MONTH, WEEKDAY & NETWORKDAYS exercises →