Dates and times
Do math with dates and times: days between, month-ends, working days, ages and hours worked.
Lessons
In the order the Roadmap teaches them.
In the full course. Beginner · 8 min
How dates really work
Know that a date is a number of days in a date format, so you can add days to a date, subtract days from it and compare two dates.
See the lessonIn the full course. Beginner · 10 min
TODAY and NOW
Count the days to a deadline or since an event with TODAY, which updates by itself, and know when NOW is the right choice.
See the lessonIn the full course. Beginner · 9 min
DATE, YEAR, MONTH and DAY
Take a date apart with YEAR, MONTH and DAY, and build a new one with DATE, such as a due date on the 15th of next month.
See the lessonIn the full course. Beginner · 9 min
Days between two dates
Count the days between two dates by subtracting them, show the result as a number, and add 1 when both end days count.
See the lessonIn the full course. Confident · 10 min
Add months with EDATE and EOMONTH
Add or subtract whole months with EDATE, and jump to the end of a month with EOMONTH, for renewals, deadlines and month-end billing.
See the lessonIn the full course. Confident · 12 min
Working days with NETWORKDAYS and WORKDAY
Count the working days between two dates with NETWORKDAYS, find a date a number of working days away with WORKDAY, and skip your holidays.
See the lessonIn the full course. Confident · 10 min
Age from date of birth
Work out an age in complete years or months from a date of birth with DATEDIF, and get a decimal age with YEARFRAC.
See the lessonIn the full course. Confident · 11 min
Weekday names and week numbers
Turn dates into day names with TEXT and day numbers with WEEKDAY, and number the weeks with WEEKNUM or ISOWEEKNUM.
See the lessonIn the full course. Confident · 9 min
Hours worked
Work out hours worked from start and end times with (end-start)*24, show them as a number, and use them for pay.
See the lessonIn the full course. Confident · 9 min
Shifts that run past midnight
Work out the hours of a shift that ends after midnight with MOD, in one formula that works for day and night shifts.
See the lessonIn the full course. Advanced · 10 min
Quarters and fiscal years from a date
Work out the quarter, the fiscal year and the fiscal quarter of any date, for a fiscal year that starts in July.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Get the full course
Every lesson in the Excel course, with new lessons added as they're written.
- All 217 Excel lessons open today, and every new one as it's written.
- The Roadmap, Skills and all eight paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Google Sheets course for US$49.