EDATE practice
EDATE returns the date a given number of months before or after a start date. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.
Syntax
EDATE(start_date, months)
What people get wrong
Use it for contract end dates and payment due dates; adding 30 days drifts, adding months does not.
Google Sheets exercise that use EDATE
- Renewal date with EDATELevel 5Pro
Practice EDATE now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free