Here's how to get the last day of the month. You know, today, this is just today's date and it's going to automatically advance every single day. We're going to use E O M O N T H end of month. And we're going to use inside of this today. Then we need zero comma zero, and we're going to get the end of the month. This will change every month. If you want the end of the last day of next month, Just put a one if you want the last day of the month, last month, negative one. There you go. That's your last day of the month inside of Google Sheets. Subscribe here to Better Sheets. I'm going to help you get the most you've ever gotten out of Google Sheets ever before. Keep subscribed here for more. Find the Start date of the Current and End date of the Current Month Google Sheets Interface Changes How to Get Last Day of the Month in Google Sheets Quickly