Google Sheets - EOMONTH
EOMONTH() does two things at the same time. It shifts a date by a certain number of months and then moves to the last day of the month of the new date. Syntax EOMONTH(date, months) Example Notes If you set the months to 0 in EOMONTH() , you go to the end of the same month.