EDATE and EOMONTH in Excel - Step-by-Step Guide

Introduction

EDATE and EOMONTH are Excel functions that help you work with dates easily. They let you find a date a certain number of months before or after a given date, or find the last day of a month. This is useful when you want to calculate due dates, expiration dates, or monthly reports.

When you want to find a date exactly 3 months after a project start date to set a deadline.

When you need to calculate a credit card expiration date 12 months from the issue date.

When preparing monthly sales reports and you want to find the last day of each month automatically.

When calculating employee contract end dates based on a start date plus a number of months.

When setting reminders for subscription renewals that happen every few months.

Steps

Step 1: Click

- a blank cell where you want the result

The cell is selected and ready for input

Step 2: Type

- the formula bar

The formula is entered in the cell

💡 Start with =EDATE or =EOMONTH to use these functions

Step 3: Enter

- the EDATE formula as =EDATE(start_date, months)

The cell shows the date that is the given number of months before or after the start_date

💡 Use a positive number for months to go forward, negative to go backward

Step 4: Enter

- the EOMONTH formula as =EOMONTH(start_date, months)

The cell shows the last day of the month that is the given number of months before or after the start_date

💡 This is useful to find month-end dates for reports or billing

Step 5: Press

- Enter key

The formula calculates and displays the date result in the cell

Before vs After

Before

Cell A1 contains 01/01/2024, and cell B1 is empty

After

Cell B1 contains 04/01/2024 after entering =EDATE(A1, 3), showing the date 3 months after Jan 1, 2024

Settings Reference

start_date

📍 Formula argument

The date from which to calculate the new date

Default: No default, must be provided

months

📍 Formula argument

Number of months to add (positive) or subtract (negative) from start_date

Default: No default, must be provided

Common Mistakes

Entering months as text with quotes like "3"

Excel treats text differently and the formula may return an error or wrong result

Enter months as a number without quotes, like 3 or -3

Using EDATE when you want the last day of the month

EDATE returns the same day of the month, not the month-end date

Use EOMONTH to get the last day of the month

Summary

EDATE calculates a date a set number of months before or after a start date.

EOMONTH finds the last day of the month a set number of months before or after a start date.

Always enter months as numbers without quotes and provide a valid start date.