Clear tutorial on the Eomonth function in Excel with examples and practical scenarios
EOMONTH function in Excel: It is a simple but effective Date -related function in the Microsoft Excel. This function returns the last day of the month after adding or subtracting a specified number of months to a given date. This function helps Manage scheduled payments From credit card to wages and financial calculations, project deadlines and planning.
|
Objective |
Value returned by function |
|---|---|
|
Take aims to get the last day of the month specified after given months. |
The Eomsth function returns the last day of the month specified after the given months. |
EOMONTH function – Syntax
=EOMONTH(start_date, months)
Required arguments
- start date – The reference date
- month – the total number of months to move forward or backwards
Compatibility of functions
Since Excel 2010, Eomonth has been available in integrated function. However, the Eomsth function was introduced for the first time on Excel 2007 as part of the ToolSpak analysis supplement.
Basic use of the Eomont function in Excel
|
Formula |
Result |
Description |
|---|---|---|
|
= Eomonth (“10-March-2025”, 0) |
March 31-2025 |
This function will return on the last day of March 2025 |
|
= Eomont (“10-March-2025”, 1) |
30-April-2025 |
As 1 is specified in the parameter of the month, the function will return on the last day of next month from the specified date |
|
= Eomonth (“10-March-2025”, -1) |
28 Féb-2025 |
This provides the rear (negative) output. As -1 is specified in the function, it returns the last day of the previous month |
|
= Eomonth (today (), 0) |
March 31-2025 |
Instead of specifying the date, we can use the function today in the start_date to obtain the exit |
|
= Eomont (A1, 3) |
Last day 3 months from the date specified in cell A1 |
The function will check the data of cell A1, then take the date of this cell, and give the last day after 3 months from this date in AI |
Note: By working with the date functions, you can get the release as random numbers instead of the date as a release. This is a very common error that users can meet, and it can be corrected by modifying the output number format.
Use of the Eomont function with example and practical scenarios
This function has practical advantages in various department such as HR pay, loan contributions, financial reports, calculations of the deadline, etc. To better understand this function, let's discuss several practical scenarios with examples.
Example 1: Calculation of the date of payment of the salary
In this scenario, an employee has resigned and the end of the month will be his last working date, and the salary will be calculated on the basis of this. Instead of manually checking the calendar, we can automate it using the Eomont function in Excel.
-
The employee's notice period begins from March 01, 2025. Therefore, to calculate the last day of the month, we can use the following Eomont function.
=EOMONTH("01-Mar-2025", 0) -
Production will take place on March 31, 2025, because it is the last day of the current month.
Example 2: Bank Calculation of loan contributions
A cooperative bank issues a 14 months for a farmer. The loan begins on March 10, 2025. Now, the bank must calculate the last day of the month after 14 months. They can simply use the Eomont function in Excel.
=EOMONTH("10-Mar-2025", 14)
- Production will take place on May 31, 2026. Thus, May 31, 2026 is the last day of the month from 14 months from the specified date. The loan is finished.
Example 3: A GPU company trying to find the last day of the previous quarter
A GPU production company wishes to examine sales data at the end of each quarter. Considering today as March 17, 2025, the company wishes to check the last day of the previous quarter which is 4 of 2024.
-
Instead of using the date, let's use the function today, as today is March 17, 2025.
= Eomonth (today (), -3)
Note: the negative sign of the informing of the month informs Excel to calculate the previous value (back value).
- The release will be December 31-2024. It will be the last day of the previous quarter.
Example 4: find the last Friday of a month (advanced use)
You can easily find the last Friday of the given input month using the Eomsth and weekday function. To do this, you may need to use the formula below.
=EOMONTH(B4,0) - MOD(WEEKDAY(EOMONTH(B4,0)),7) - 1
|
Entry date |
Last Friday |
Formula used to calculate last Friday from the given date |
|---|---|---|
|
June 15-2023 |
27-Jandi 2023 |
= EOMONTH (B4.0) – MOD (on weekdays (EOMONTH (B4.0)), 7) – 1 |
|
20 Féb-2023 |
24-FEB-2023 |
= EOMONTH (B5.0) – MOD (on weekdays (EOMONTH (B5.0)), 7) – 1 |
|
March 25-2023 |
31-March-2023 |
= EOMONTH (B6.0) – MOD (weekdays (EOMONTH (B6.0)), 7) – 1 |
Functions used:
- Eomsth: This function was used to return on the last day of the month according to the specified number of months before or after
- MOD: This function is used to return a reminder of the division.
- Week day: This function is used to return the day of the week as a numerical value.
Other advanced examples:
The following examples explain the advanced use of the EOMONTH function to return the output according to the input dates given in several scenarios.
|
Entry date |
Final results |
Formula used for? |
Formula used? |
|---|---|---|---|
|
January 15, 2023 |
February 01, 2023 |
Formula used to calculate the first day of next month |
= Eomont (B4, 0) + 1 |
|
February 20, 2023 |
8 |
Formula used to calculate the number of days until the end of the month |
= Eomont (B5.0) – B5 |
|
March 25, 2023 |
April 03, 2023 |
Formula used to find the first Monday of next month |
= EOMONTH (B6.0) + 1 + MOD (8 weeks (EOMONTH (B6.0) +1.2), 7) |
|
April 14, 2023 |
July 31, 2023 |
Formula used to calculate a maturity date 3 months after a start date |
= Eomont (B7.3) |
|
August 19, 2023 |
August 31, 2023 |
Formula used to find the last working day of the month |
= Working day (Eomonth (B8.0) + 1, -1) |
|
December 28, 2023 |
January 31, 2024 |
Formula to calculate the date of the end quarter |
= Eomont (B9.3 -Mod (month (B9) -1.3)) |
Take away
Like the other functions related to the essential date such as the Edate function, the date function, etc., the omanonème in the Excel is a useful function for calculating the last day of the month from the specified month. This tutorial is initially published on how to use the Eomonth function in Excel?
