Formuladrill

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

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