How to Use EOMONTH() in Google Sheets

Description

Returns a date representing the last day of a month which falls a specified number of months before or after another date.

How To Actually Use EOMONTH() in Sheets

EOMONTH(start_date, months)

In cell B1, use the EOMONTH formula to find the last day of the month that is 2 months after the date in cell A1. The result should be a valid date.

Your formula

Hints (2)

Locale Separator ,

2 Better Sheets Tutorials

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.

EOMONTH() TODAY()

Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.

EOMONTH() HOUR() MONTH() NOW() SPARKLINE() +3 more

Learn more about the EOMONTH() formula:

Generate a EOMONTH() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses EOMONTH(). 2 free AI generations, no signup. Members get unlimited use.