WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » EOMONTH in Excel

EOMONTH in Excel

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Excel EOMONTH Function

EOMONTH is a worksheet date function in excel which calculates the end of the month for the given date by adding a specified number of months to the arguments, this function takes two arguments one as date and another as integer and the output is in date format, the method to use this function is as follows =EOMONTH( Start Date, Months).

Formula

EOMONTH Formula in Excel

It has two arguments, out of which both are required. Where,

  • start_date = This represents the starting date. The date must be entered by using the DATE function. E.g.: DATE (2018,5,15)
  • months = The number of months before or after the start_date. If the number is positive, it indicates the future date. If the number is negative, it yields a date in the past.

The return value of the EOMONTH is a serial number that can further be converted into a user-friendly date format using the DATE function.

How to Use the EOMONTH Function in Excel? (with Examples)

You can download this EOMONTH Function in Excel Template here – EOMONTH Function in Excel Template

Example #1 – 1 month forward

As shown in the above EOMONTH formula,

=EOMONTH (B2,1)

EOMONTH is applied to the cell B2, which has a date value of 21st Aug’ 2018. The 2nd parameter value is 1, which indicates 1-month forward, i.e., September.

Cell C2 represents the resulting cell wherein the value is 43373, which is the serial number of the resultant date, i.e., the last day of the month September of the year 2018. The serial number is further converted into a readable date format using the TEXT function in excel, which takes the value to be converted and the date format as its parameters.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Here, the value from cell C2 is converted into the date format as ‘dd/mm/yyyy,’ and the resultant date is displayed in cell D2, which is 30th Sept. 2018.

Example 1

Example #2 – 6 Months Backward

As shown in the below EOMONTH formula,

=EOMONTH (B4, -6)

EOMONTH in excel is applied on the cell B4, which has date value as 21st Aug’ 2018. The 2nd parameter value is -6, which indicates a 6-month backward, i.e., February. Cell C4 represents the result cell wherein the value is 43159, which is the serial number of the resultant date, i.e., the last day of the month February of the year 2018.

The serial number is further converted into a readable date format using the TEXT function in excel, which takes the value to be converted and the date format as its parameters. Here, the value from cell C4 is converted into the date format as ‘dd/mm/yyyy,’ and the resultant date is displayed in cell D4, which is 28th Feb. 2018.

Example 2

Example #3 – The Same Month

As shown in the below EOMONTH formula,

=EOMONTH (B6, 0)

EOMONTH function is applied to the cell B6, which has a date value of 21st Aug’ 2018. The 2nd parameter value is 0, which indicates the same month, i.e., August. Cell C6 represents the result cell wherein the value is 43343, which is the serial number of the resultant date i.e., the last day of the month August of the year 2018.

The serial number is further converted into a readable date format using the TEXT function in excel, which takes the value to be converted and the date format as its parameters. Here, the value from cell C6 is converted into the date format as ‘dd/mm/yyyy,’ and the resultant date is displayed in cell D4, which is 31st Aug. 2018.

EOMONTH Example 3

Things to Remember

  • If the start_date is not a valid date, EOMONTH returns the #NUM! indicating an error in the number.
  • If the resultant date i.e., after adding or deducting the given number of months (the 2nd parameter), is invalid then, EOMONTH returns #NUM! indicating an error in the number.
  • If the start_date is written in an un-appropriate format then, the EOMONTH function returns #VALUE! indicating an error in the value.
  • The return value of the EOMONTH function excel is a serial number that can further be converted into a user-friendly date format using the DATE Excel function.
  • By default, Excel treats January 1, 1900, as serial number 1, and January 1, 2008, as 39448, indicating it is 39,448 days after January 1, 1900.

EOMONTH in Excel Video

Recommended Articles

This has been a guide to EOMONTH in Excel. Here we discuss how to use EOMONTH in Excel and its formula along with practical examples and a downloadable template. You may also look at these useful functions in excel –

  • MONTH Function in Excel
  • YEAR Function
  • NOW In Excel | Examples
  • WORKDAY in Excel
3 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download EOMONTH Function in Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More