Introduction
The EOMONTH function in Excel helps you find the last date of a month based on a starting date. You can use it to calculate month-end dates, payment deadlines, subscription expiry dates, and monthly reporting periods. It can also find the last date of previous or future months.
What Is the EOMONTH Function in Excel?
The EOMONTH function returns the last date of a month after adding or subtracting a specified number of months from a starting date.
For example, suppose you have a date of 15-Jan-2026 and want to find the last date of that same month.
=EOMONTH(A2,0)
Expected Result: 31-Jan-2026
The function can also calculate the last date of previous or future months.
0returns the last date of the current month.1returns the last date of the next month.2returns the last date of the month after next.-1returns the last date of the previous month.-2returns the last date of two months before.
EOMONTH Function Syntax
=EOMONTH(start_date,months)
Understanding the Arguments
| Argument | Meaning |
|---|---|
| start_date | The starting date from which Excel calculates the month-end date. |
| months | The number of months to move forward or backward. |
How Does the Months Argument Work?
The months argument tells Excel how many months to move from the starting date before finding the last day of that month.
| Months Value | Meaning |
|---|---|
| 0 | Last day of the current month |
| 1 | Last day of the next month |
| 2 | Last day of two months ahead |
| 3 | Last day of three months ahead |
| -1 | Last day of the previous month |
| -2 | Last day of two months before |
Example:
Suppose cell A2 contains 15-Jan-2026.
| Formula | Expected Result |
|---|---|
=EOMONTH(A2,0) | 31-Jan-2026 |
=EOMONTH(A2,1) | 28-Feb-2026 |
=EOMONTH(A2,2) | 31-Mar-2026 |
=EOMONTH(A2,-1) | 31-Dec-2025 |
=EOMONTH(A2,-2) | 30-Nov-2025 |
Important: EOMONTH returns an actual Excel date value. If the result appears as a number, format the cell as a Date.
Practical Examples of EOMONTH Function in Excel
Question 1: Find the Last Date of the Current Month
Problem Statement:
An accounts department wants to find the last date of the month for different transaction dates.
Transaction Data:
| Transaction ID | Transaction Date |
|---|---|
| T101 | 05-Jan-2026 |
| T102 | 12-Feb-2026 |
| T103 | 18-Mar-2026 |
| T104 | 25-Apr-2026 |
Excel Formula:
Enter this formula in C2:
=EOMONTH(B2,0)
Expected Result:
| Transaction ID | Transaction Date | Month-End Date |
|---|---|---|
| T101 | 05-Jan-2026 | 31-Jan-2026 |
| T102 | 12-Feb-2026 | 28-Feb-2026 |
| T103 | 18-Mar-2026 | 31-Mar-2026 |
| T104 | 25-Apr-2026 | 30-Apr-2026 |
Explanation:
The formula uses the transaction date as the starting date. The 0 tells Excel to stay in the same month and return its final date.
For example, 12-Feb-2026 becomes 28-Feb-2026 because February has 28 days in 2026.
Concept Covered: Finding the last date of the current month.
Question 2: Find the Last Date of the Next Month
Problem Statement:
A company wants to calculate the last date of the month following each employee’s joining month.
Employee Data:
| Employee Name | Joining Date |
|---|---|
| Rahul | 15-Jan-2026 |
| Priya | 10-Feb-2026 |
| Amit | 20-Mar-2026 |
| Neha | 05-Apr-2026 |
Excel Formula:
Enter this formula in C2:
=EOMONTH(B2,1)
Expected Result:
| Employee Name | Joining Date | Next Month-End |
|---|---|---|
| Rahul | 15-Jan-2026 | 28-Feb-2026 |
| Priya | 10-Feb-2026 | 31-Mar-2026 |
| Amit | 20-Mar-2026 | 30-Apr-2026 |
| Neha | 05-Apr-2026 | 31-May-2026 |
Explanation:
The 1 in the formula tells Excel to move one month forward and return the last date of that month.
For Rahul, Excel moves from January to February and returns 28-Feb-2026.
Concept Covered: Calculating the last date of the following month.
Question 3: Find the Last Date of the Previous Month
Problem Statement:
An accounts team wants to identify the closing date of the previous month for each transaction.
Transaction Data:
| Transaction ID | Transaction Date |
|---|---|
| T201 | 15-Jan-2026 |
| T202 | 10-Feb-2026 |
| T203 | 20-Mar-2026 |
| T204 | 05-Apr-2026 |
Excel Formula:
Enter this formula in C2:
=EOMONTH(B2,-1)
Expected Result:
| Transaction ID | Transaction Date | Previous Month-End |
|---|---|---|
| T201 | 15-Jan-2026 | 31-Dec-2025 |
| T202 | 10-Feb-2026 | 31-Jan-2026 |
| T203 | 20-Mar-2026 | 28-Feb-2026 |
| T204 | 05-Apr-2026 | 31-Mar-2026 |
Explanation:
The -1 tells Excel to move one month backward and return the last date of that month.
For the transaction dated 10-Feb-2026, Excel returns 31-Jan-2026.
Concept Covered: Calculating previous month-end dates.
Question 4: Calculate a Subscription Expiry Date
Problem Statement:
A software company provides monthly subscriptions. The team wants to calculate the last date of the subscription month.
Subscription Data:
| Customer Name | Subscription Start Date |
|---|---|
| Aman | 05-Jan-2026 |
| Riya | 12-Feb-2026 |
| Karan | 20-Mar-2026 |
| Simran | 08-Apr-2026 |
Excel Formula:
Enter this formula in C2:
=EOMONTH(B2,0)
Expected Result:
| Customer Name | Subscription Start Date | Month-End Date |
|---|---|---|
| Aman | 05-Jan-2026 | 31-Jan-2026 |
| Riya | 12-Feb-2026 | 28-Feb-2026 |
| Karan | 20-Mar-2026 | 31-Mar-2026 |
| Simran | 08-Apr-2026 | 30-Apr-2026 |
Explanation:
The formula returns the last date of the month in which the subscription starts.
For example, a subscription starting on 20-Mar-2026 gets a month-end date of 31-Mar-2026.
Concept Covered: Calculating the month-end date for subscription records.
Question 5: Calculate the Last Date After Three Months
Problem Statement:
A company wants to calculate the last date of the month that falls three months after each project start date.
Project Data:
| Project Name | Start Date |
|---|---|
| Website Development | 10-Jan-2026 |
| Mobile Application | 15-Feb-2026 |
| Database Upgrade | 20-Mar-2026 |
| Software Testing | 05-Apr-2026 |
Excel Formula:
Enter this formula in C2:
=EOMONTH(B2,3)
Expected Result:
| Project Name | Start Date | Month-End After 3 Months |
|---|---|---|
| Website Development | 10-Jan-2026 | 30-Apr-2026 |
| Mobile Application | 15-Feb-2026 | 31-May-2026 |
| Database Upgrade | 20-Mar-2026 | 30-Jun-2026 |
| Software Testing | 05-Apr-2026 | 31-Jul-2026 |
Explanation:
The number 3 tells Excel to move three months forward from the starting date and return the last date of the resulting month.
For Website Development, Excel moves from January to April and returns 30-Apr-2026.
Concept Covered: Finding a future month-end date using a positive month value.
Question 6: Calculate the Last Date Two Months Before
Problem Statement:
A finance department wants to find the month-end date two months before each invoice date.
Invoice Data:
| Invoice Number | Invoice Date |
|---|---|
| INV101 | 15-Jan-2026 |
| INV102 | 10-Feb-2026 |
| INV103 | 20-Mar-2026 |
| INV104 | 05-Apr-2026 |
Excel Formula:
Enter this formula in C2:
=EOMONTH(B2,-2)
Expected Result:
| Invoice Number | Invoice Date | Month-End Two Months Before |
|---|---|---|
| INV101 | 15-Jan-2026 | 30-Nov-2025 |
| INV102 | 10-Feb-2026 | 31-Dec-2025 |
| INV103 | 20-Mar-2026 | 31-Jan-2026 |
| INV104 | 05-Apr-2026 | 28-Feb-2026 |
Explanation:
The -2 tells Excel to move two months backward before finding the final date of that month.
For INV103, Excel moves from March to January and returns 31-Jan-2026.
Concept Covered: Calculating earlier month-end dates using negative month values.
Question 7: Calculate the Financial Month-End Date
Problem Statement:
A company wants to calculate the last date of the financial month for each sales transaction. The finance team uses a three-month reporting cycle and wants to find the last date three months after each transaction month.
Sales Data:
| Sales ID | Transaction Date |
|---|---|
| S101 | 12-Jan-2026 |
| S102 | 18-Feb-2026 |
| S103 | 05-Mar-2026 |
| S104 | 20-Apr-2026 |
Excel Formula:
Enter this formula in C2:
=EOMONTH(B2,3)
Expected Result:
| Sales ID | Transaction Date | Reporting Period End |
|---|---|---|
| S101 | 12-Jan-2026 | 30-Apr-2026 |
| S102 | 18-Feb-2026 | 31-May-2026 |
| S103 | 05-Mar-2026 | 30-Jun-2026 |
| S104 | 20-Apr-2026 | 31-Jul-2026 |
Explanation:
The formula moves three months forward from each transaction date and returns the last date of the resulting month.
For example, a transaction dated 12-Jan-2026 returns 30-Apr-2026.
Concept Covered: Using EOMONTH to calculate future reporting period end dates.
Student Practice Tasks
Try solving these tasks using only the EOMONTH function.
Task 1: Find the Current Month-End
| Employee | Joining Date |
|---|---|
| Mohit | 05-May-2026 |
| Sneha | 12-Jun-2026 |
| Varun | 20-Jul-2026 |
Find the last date of each joining month.
Task 2: Find the Next Month-End
| Customer | Registration Date |
|---|---|
| Customer A | 10-Jan-2026 |
| Customer B | 15-Feb-2026 |
| Customer C | 20-Mar-2026 |
Find the last date of the next month for each customer.
Task 3: Find the Previous Month-End
| Invoice | Invoice Date |
|---|---|
| INV201 | 10-Apr-2026 |
| INV202 | 15-May-2026 |
| INV203 | 20-Jun-2026 |
Find the last date of the previous month for each invoice.
Final Student Challenge: Build a Monthly Payment Schedule
Problem Statement:
You are working in the accounts department. Your manager wants a payment schedule showing the last date of the current month, the next month, and the month after next.
Use the following data:
| Customer Name | Invoice Date |
|---|---|
| Rahul | 15-Jan-2026 |
| Priya | 20-Feb-2026 |
| Amit | 10-Mar-2026 |
| Neha | 05-Apr-2026 |
| Karan | 18-May-2026 |
Your Tasks:
- Find the last date of the current month using
0. - Find the last date of the next month using
1. - Find the last date of the month after next using
2. - Find the last date of the previous month using
-1.
Expected Report Structure:
| Customer Name | Invoice Date | Current Month-End | Next Month-End | After Next Month-End | Previous Month-End |
|---|---|---|---|---|---|
| Rahul | 15-Jan-2026 | Your Result | Your Result | Your Result | Your Result |
| Priya | 20-Feb-2026 | Your Result | Your Result | Your Result | Your Result |
| Amit | 10-Mar-2026 | Your Result | Your Result | Your Result | Your Result |
| Neha | 05-Apr-2026 | Your Result | Your Result | Your Result | Your Result |
| Karan | 18-May-2026 | Your Result | Your Result | Your Result | Your Result |
Complete the report by applying the correct month value in each EOMONTH formula.
Key Takeaways
- EOMONTH returns the last date of a month.
- Its syntax is
=EOMONTH(start_date,months). - Use
0to find the current month’s last date. - Use positive numbers to move forward.
- Use negative numbers to move backward.
- EOMONTH automatically handles months with 28, 29, 30, or 31 days.
- The result is a real Excel date value.
- Format the result cell as Date if Excel displays a serial number.
Frequently Asked Questions (FAQs)
1. What is the EOMONTH function in Excel?
EOMONTH returns the last date of a month based on a starting date and a specified number of months.
2. What is the syntax of EOMONTH?
The syntax is:
=EOMONTH(start_date,months)
3. What does 0 mean in the EOMONTH function?
Zero means Excel should return the last date of the same month as the starting date.
4. How do I find the last date of the next month?
Use 1 as the months argument.
=EOMONTH(A2,1)
5. How do I find the last date of the previous month?
Use -1 as the months argument.
=EOMONTH(A2,-1)
6. Can EOMONTH calculate future dates?
Yes. You can use positive month values such as 1, 2, 3, or 6 to calculate future month-end dates.
7. Can EOMONTH calculate past dates?
Yes. Use negative month values such as -1, -2, or -3 to calculate previous month-end dates.
8. Why does EOMONTH show a number instead of a date?
Excel stores dates as serial numbers. If the result appears as a number, change the cell format to Date.
9. Does EOMONTH automatically handle February?
Yes. It automatically returns the correct last date of February, including 28 days in a normal year and 29 days in a leap year.
10. Is EOMONTH useful for monthly reports?
Yes. It is useful for calculating month-end dates for sales reports, financial reports, invoices, subscriptions, and payment schedules.

