Although EOMONTH is a more convenient function, it won’t accept a range of dates in anarray formula.
In that case, you could use the alternative above.
Get last day of month
To calculate the last day of a month based on a given date, you can use the EOMONTH function. In the example shown, the formula in cell B5 is: =EOMONTH(B5,0)
