FinanceTier 712 minintermediate

Loan Maturity Date via EDATE

Calculate a loan's maturity date from its start date and term in months, without drifting off the real calendar date.

What you will learn

• Use EDATE to move a date forward by a number of calendar months
• Explain why treating a month as a fixed 30 days drifts further off the real date the longer the term runs
• Recognise EDATE as the correct tool over manual day-count arithmetic

Excel skills

EDATE · Date and Time Functions

The task

Each loan has a start date and a term in months. Work out the maturity 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