Working with dates

Intermediate 1 hr 50 min 12 exercises

Build confidence with date math, business days, deadlines, and other practical date workflows.

What you'll learn

Construct and decompose dates with DATE, YEAR, MONTH, and DAY
Calculate elapsed time between dates in days, months, or years using DAYS and DATEDIF
Shift dates by whole months with EDATE and find month-ends with EOMONTH for billing and deadline workflows
Compute business-day counts and the next workday using NETWORKDAYS and WORKDAY
Aggregate values over rolling date windows by combining SUMIFS or AVERAGEIFS with TODAY()

Functions you'll practice

AVERAGEIFS CONCATENATE DATE DATEDIF DAY DAYS EDATE EOMONTH MONTH NETWORKDAYS SUMIFS TODAY WORKDAY YEAR

Start track

Exercises in this track

0 of 12 completed 0%

Days between dates

Beginner

Calculate how many days between order date and ship date.

DAYS

Start

Build a date from separate parts with DATE

Beginner

Use the DATE function to combine separate year, month, and day columns into a proper Excel date.

DATE

Start

Extract date parts from a date

Beginner

Extract month, day, and year values from a date column.

MONTH DAY YEAR

Start

Making an always up-to-date copyright message

Beginner

In this exercise, we’re going to use the TODAY function, the YEAR function and the CONCATENATE function to create an up-to-date copyright message. The...

YEAR TODAY CONCATENATE

Start