Mini Calendar

0:00 So you may be familiar with seven day week calendars or a monthly calendar that has seven columns and has space to fill in. What you want to do, maybe you can print this out, but I wanna make a mini calendar, one that sits in the top left corner of my sheet and only has the numbers of the month. I'm gonna insert seven columns. That's 4, 5, 6, 7. I'm gonna make them very tiny right there. Now I have this formula already created. What we're doing is we're taking today, let's go and let's look at this as we type it out. We're taking today. And we're gonna wrap around it. E-O-M-O-N-T-H. Now we need the start date and the month, and we're gonna add negative one. That means whatever today's date is, find out what month it is.

0:46 Find out the last day of last month, negative one, the month before that. And then or end parentheses and add plus one. Now that is the first of the month, no matter what day it is. But we don't want to only have the first of the month in that top left corner. We want the first Sunday or any other day before Sunday. So we're going to do minus weekday. And what is the day of that today? Again, we're gonna wrap E-O-M-O-N-T-H around that end of month in parentheses plus one, and that's the 25th. So we actually need to add plus one again. But you see we can't fit the whole day here. So we're gonna have format number and we're gonna scroll down to custom date and time.

1:32 And here we're gonna pick the day. But we're going to have they without leading zeros . We're gonna pick that and click apply. And then we need to very small text here. So we're have font size eight, and that is 26. So now in the next column, take this whole formula , copy and paste it, and we're gonna add plus two. That's going to be the last Monday of last month. We wanna copy and paste just the format only . We're gonna do that for the whole thing here, here. Now we copy paste again, but now plus three copy paste again. Plus four copy paste each one, five plus six and plus seven. There's the first week of our calendar. Now how do we do the next one? We do exactly as we did here.

2:18 Just add seven. So we're gonna take this, we're go equals a three plus seven. So we take that format and that whole formula and then delete the whole formula and put equals this plus seven. Or we can do on the left side a four plus one. And now we have a big cell here. Let's insert a row below and let's make these all the same size. Let's say 20. Let's insert a row below here and we need to move some of our calendar around. As we collapsed a little bit of space. There we go and merge these. So that saves the formatting over there. But let's add a few more rows. We need actually probably just five rows. And now here's an easy part is we can copy paste this and it automatically

3:04 changes the cell reference and says, plus seven can change this or copy and paste this without much difference. And there is a tiny calendar in our corner of our sheet and this is gonna be updated. Every month we zoom in a little bit and you can see we can change the font up here. I like quicksand. There's gonna be some fonts that don't work very well, but some fonts that work very, very well. Small. I don't think a play fair. Works very well, quicksand works good. Pacifico. Okay. Aerial is fine. Let's try per prime. It's okay. It's a little squished, but it's fine actually. Very nice. I just like quick San, but there's your mini calendar. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google

3:53 sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.