• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

EOMONTH Function

The Excel EOMONTH function calculates the last day of the month a specified number of months before or after a date.

EOMONTH is often used to calculate the due date for an investment that falls on the last day of a month.

The syntax for the EOMONTH function is:

=EOMONTH(start_date, months)

ArgumentPurpose
Start_dateThe date representing the start date
MonthsThe number of months before or after the start date. Enter the number as a negative for months before

The examples below demonstrate the EOMONTH function being used to calculate the last day of the month a specified number of months before and after the date in the spreadsheet.

Excel EOMONTH function
FunctionResult
=EOMONTH(A2, 3)30/06/2010
=EOMONTH(A2, 0)31/03/2010
=EOMONTH(A2, -2)31/01/2010

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • Non-Adjacent Columns with FILTER Function
  • Moving Average in Excel
  • Excel IMAGE Function – Insert Images from a Cell Value
  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·