Use Excel's EOMONTH function to add or subtract months – Knowligent
Use Excel's EOMONTH function to add or subtract months

Use Excel's EOMONTH function to add or subtract months

Home › How to, Tech › Use Excel's EOMONTH function to add or subtract months
Summary by Lifewire • Chester Tugwell on Youtube • Published 6 years ago

This article explains how to use the EOMONTH function (short for End of Month) in Microsoft Excel to calculate a maturity date or expiration date for an investment or project that occurs at the end of the month. Instructions apply to Excel 2019-2010 and Excel for Microsoft 365.

How to Add or Subtract Months from a Date in Excel

The syntax of a function refers to the layout of the function and includes the function name, parentheses, commas, and arguments.

The syntax for the EOMONTH function is:

Start Date (required): The start date of the project or event in question.