You're going to find out how to get last month's name into a cell. So here we have September, this is how we do it. I'm going to show you step by step how to do that. You might know about the formula today, which gives you today's formula , which gives you today's date, and this will be automatically updated every single day, no matter what you do. It'll constantly be changing. But how do we get the name of the month? Well, we need to first get the date. last month. So we're going to do E O M O N T H end of month. And the second option here is going to be the months. If we put in zero, that's this month, but if we do negative one, that's last month, it's the end of the month, last month. And now we wrap all of that with text and we use a format , which is M M M M.

It's going to be four M's And that's how we get the name of last month in Google Sheets. If you like this and you want to get more tips, tricks, and get more out of Google Sheets in general, follow here on Better Sheets on YouTube. What is this Ampersand Doing in Google Sheets? Figure Out Frequency of Numbers First 3 Letters of the Month in Google Sheets