Explainry Tutorials to Expert in IT

EOMONTH Function in Google Sheets

The EOMONTH function (End of Month) returns the last date of a month after adding specified number of months to a date. For example, the formula =EOMONTH(“12 Dec 2019”,1) returns “31 Jan 2020” which is one month later than the specified date.


EOMONTH(start_date, months)

start_date – Required. The start date to use in the calculation.

months – Required. The number of months to add after the start_date.


Below example illustrates how to get the last and first day of the current month.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved