How to List Every Day This Month in Google Sheets

0:00 I want to list every single day this month in a date column, but I want to do it sort of automatically. I want this to be every day of the month, whatever month we're in. Right now, we're in February. So how do I do this? Well, I'm going to use a o m o n h. This is end of month, and we're going to use today to say what day is today, but we're going to say negative one. around it, plus one. So this will give us the very first day of the month, whatever month we're in. Now, if I just take the next cell and I go equals plus, equals this cell, A3, plus one, I'm going to get the next day. And now I can copy paste this down 30 some odd times. Places actually 31 because that's the most in any particular month I'm Find the Start date of the Current and End date of the Current Month Copy Date to Next Cell Automatically How to Get First of the Month in Google Sheets Quickly

0:50 gonna get every day of the month, but check this out at the end. I'm gonna get this 31 Actually, we need more because we have to have 30 Let's see, count 30, now this is 31. So the most any month is going to have is 31, but in February here we have 3 more. So how do we show only this month's dates? Well we can wrap this with if, if this, and say month, is equal to the month of today, which is true for February, let's make sure we have enough, there we need one more parenthesis, Now, if that's true, and the month is this month, then we want to show this end of month plus one. And if not, we need one more, one less parenthesis. Ben Asks: How Do I Add 1 Month? Mini Calendar

1:36 And if not, show nothing. So the first of the month is always going to be this way. But here, let's do the same. If month of this is equal to month of today, then we're going to show this A3 plus one. And if not, we're going to show nothing. So again, the first two doesn't really matter, because we'll always have at least 30. But let's copy paste this all the way down, and you see March disappeared down here. So now we only see February. So now we have a list of just this month, every single day in this month. We can add the task, we can get the day of the week, we can say equals this. Let's copy paste this all the way down, one more. And then we can just change this formatting to show. Switch Months Menu - Design a Better Dashboard Part 4 80 Years In 1 Spreadsheet Mini Calendar

2:22 Number , custom date, and instead of the day, we're just going to show Tuesday. Let's get the full name, apply. And there, we get the full day of the week, right here, based on this. But we're only going to show this if it's this month. So next month, March, is going to show more days here, automatically. This today formula is just going to keep going every single day, it's going to move forward and forward, and all day. The time, this will show a list of every single day, whatever month we're in. Thanks for watching. I hope you enjoyed. If you're looking to get more out of your Google sheets, do more things in Google sheets you never thought possible. Do cool formula combinations like today and end of month or month. Google Sheets Interface Changes Google Sheets Interface Changes Big Year - a Whole Year in One Google Sheets Tab Big Year

3:08 Subscribe right now. It's free here on YouTube.