Pro lesson · 7 exercises · first one free
Working with dates
Date math, YEAR/MONTH/DAY, DATE, EOMONTH, EDATE and NETWORKDAYS.
Functions you'll practice
- YEAR
- MONTH
- DAY
- DATE
- EOMONTH
- EDATE
- NETWORKDAYS
How the lesson works
7 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly, with hints when you're stuck.
The lesson starts with
Behind the scenes a date is a number: the count of days since the start of 1900. That's why you can add and subtract dates.Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 7, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.