How to Get First of the Month in Google Sheets
Learn how to easily find the first day of the month in Google Sheets using a simple formula that leverages the EOMONTH function. This video provides a quick and effective method to retrieve the first date of the current, previous, or next month.
Here's how to get the first of the month of any month that we're currently in. You may know today, this is a formula that automatically gets today's date, but what if we want the actual first date of the month, which right now would be February 1st? We're gonna have to use a little bit of a trick formula . We need E O M O N T H, end of month. We're gonna use today here. to get the start date of this month. Normally you do one, it's next month. If you do zero, it's this month. And if you do negative one, it's last month, but that's the end of the last month, but the first of the month is always just plus one to the last day of last month. So this formula . End of month, today, minus one, plus one, is going to get us the first of the month.
If you want the first of last month, just do negative two. If you want first of next month, just do one, or two, if the first in two months. hope you enjoyed this. Subscribe today to BetterSheets. Get more of these cool tricks, tips, how tos. Get more out of your Google Sheets than you ever thought you ever could.