Administration and Executive AssistantTier 720 minintermediate

EDATE for Calendar Months

Find a contract's renewal date by adding real calendar months, not a fixed day count.

What you will learn

• Use EDATE to add a number of months to a date, landing on the correct calendar day
• Explain why months are not a fixed number of days
• Recognise that adding termMonths*30 days drifts from the real date, more so for longer terms

Excel skills

EDATE · Date Calculations

The task

Each contract has a start date and a term in months. Work out the renewal date for each one, in column C - the same day of the month, that many months later.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free