EDATE practice
EDATE returns the date a given number of months before or after a start date. Below are the 1 Excel exercise on Formuladrill 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.
Excel exercise that use EDATE
- Contract end dateLevel 4Pro
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