SheetsdrillDATEDIF practice
DATEDIF returns the number of complete days, months or years between two dates. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.
Syntax
DATEDIF(start_date, end_date, unit)
What people get wrong
The unit "Y" counts full years only, which is what years of service or age needs.
Google Sheets exercise that use DATEDIF
- Full years of serviceLevel 5Pro
Practice DATEDIF now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free