Working with dates
Build confidence with date math, business days, deadlines, and other practical date workflows.
Exercises in this track
Days between dates
Calculate how many days between order date and ship date.
Build a date from separate parts with DATE
Use the DATE function to combine separate year, month, and day columns into a proper Excel date.
Extract date parts from a date
Extract month, day, and year values from a date column.
Making an always up-to-date copyright message
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...
Calculate age from birthdate
Calculate an employee's current age from their date of birth.
Find end of month with EOMONTH
Use EOMONTH to calculate the payment due date at the end of the following month for each invoice.
Calculate project review dates
Calculate review dates by shifting a shared kickoff date by whole months and moving weekend results to the next business day.
Calculate business days between
Calculate the number of business days between order and delivery.
Next business day
Calculate the next business day from each invoice date.
AVERAGEIFS with date range and category
Calculate average deal size by product category for a specific fiscal quarter.