FinanceTier 712 minbeginner

Month-End Close Date

Calculate the actual last day of the month for any reporting date, including leap years.

What you will learn

• Use EOMONTH to find the last day of a given month
• Explain why hard-typing month-end dates silently breaks in a leap year
• Recognise EOMONTH as the correct tool over manual date arithmetic

Excel skills

EOMONTH · Date and Time Functions

The task

For each reporting date, calculate the actual last day of that month - including in a leap year. In B2, write a formula using EOMONTH.

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