How to List Every Monday This Year
Learn how to list every Monday of the year using Google Sheets with simple formulas and formatting techniques. This tutorial provides a step-by-step guide to create a complete list of Mondays for any given year.
Here's how to list every Monday of this year. We just want a date of every single Monday. The very first Monday of the year was equals date 2025 month one day six. That's the 6th of January and that was a Monday. We can actually tell by doing this formatting our cell as a Monday, we can just go format number and choose this day of the week. So it's literally the date, but just formatted as a Monday. How do we list every single Monday of this year? We're gonna go equals this A3 plus 7. Now, 13th, is that a Monday? Equals this, yes it is. Now, we just have to copy paste this 52 times. Free 2026 Yearly Calendar Template
And we can delete the ones that are from next year, and there we go. We have a list now. Of 52 Mondays in 2025. If we want to change this year, maybe it's 2026 already when you're watching this. There we go, 2026, but is this a Monday? No, it's a Tuesday, so we just need to change the 6 to a 5. And there's every single Monday of 2026 as well. Hope you enjoyed that video. If you're looking for more interesting combinations of formulas, more automations, check out other videos here on BetterSheets. It's free here on YouTube. Over at bettersheets. co, you gotta pay a monthly membership. Go check that out too if you want. But subscribe here for free here on YouTube. Richard Asks: Copy Template Tab and Rename to Date Every Week 80 Years In 1 Spreadsheet Create an Automated Extended Weekly Calendar View in Google Sheets