Pro lesson · 5 exercises · first one free
More date tools: DATEDIF, DAYS, WEEKDAY and WORKDAY
About this lesson
Count whole years, find the day of the week, and add working days.
Text and dates · 5 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.
What you'll practise
- Counting complete years between two dates
- Counting the days between two dates
- Finding whether a date is on a weekend
- Adding working days to a date
- Choosing the right date function
Functions you'll use
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, 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.