Step-by-Step Guide to Making a Monthly Calendar in Google Sheets (Perfect for Beginners)

[@MondayGoalGirl]

At timestamp 02:15 (it's the last cell with number 8) . I made a mistake in the last day of the week . The formula should be =MOD(IF($C$25="Sunday",7,8),7) 😅

[@gymnstmini]

When I use this formula, I get "0".

[@MondayGoalGirl]

@@gymnstmini hi, when you select Sunday then you will get "0". this is because of how the MOD function works.

[@RuthJazmines]

@@MondayGoalGirl If Sunday is the first day That I put in my calendar what formula should we put? Thank you

[@MondayGoalGirl]

@@RuthJazmines hi , the formula work for both Sunday and Monday selection! 😁

[@rachelsales1164]

The best tutorial I've ever seen ❤

[@DanaDavis2014]

MondayGoalGirl, this is great! Thank you so much for a great product and a great tutorial.

[@MondayGoalGirl]

You are very welcome! more videos to come 🥰

[@ejeteb]

This is amazing, thank you

[@MondayGoalGirl]

You're welcome! I'm so glad you liked it! 😄

[@georgetteshane]

Can you make a content calendar for vitual assistant, i hope i can learn how to do this all.. thank you so much..

[@MondayGoalGirl]

What do you need in a content calendar for a virtual assistant? Please give me more details of what you need to track so that in the future video I will try my best to build the template! 😄

[@IrishandmadeartENG]

thank you for this tutorial. 🥰 I do have a question. How do you add the function that the current day is highlighted? 🙂💜

[@MondayGoalGirl]

=AND(EQ(G8, Day(Today())), EQ(TEXT(TODAY(), "MMMM"), $C$20)). please select the calendar date range, which for this sheet was (G8:S8,G16:S16,G24:S24,G32:S32,G40:S40) this is an example of a Custom Formula for Conditional Formatting in my calendar. And G8 is the starting cell of the range and C20 is the selected month. Let me know if it works for you! :)

[@IrishandmadeartENG]

@@MondayGoalGirl you are amazing! Thank you so much!🥰🙏💜

[@IrishandmadeartENG]

@@MondayGoalGirlI tried and it does not work unfortunately 😢Perhaps a good idea for a next tutorial? 😉🥰

[@IrishandmadeartENG]

Unfortunately, I have another issue, I use Monday as a starting day and when the 1st day or the month is on a Sunday, the formula only works for when I set Sunday as a starting day. When I put it on Monday, the calendar stays empty. 🥺

[@MondayGoalGirl]

@@IrishandmadeartENG I'm glad that you found a bug in my templates .😅 I made a mistake in the last day of the week . The formula should be =MOD(IF($C$25="Sunday",7,8),7) This formula will return the number of the day of the week, where Sunday is 1 and Saturday is 7.

[@BeancaMcCall]

Is there a way that the date that input for the task be like a continuous date? For example if the date is 01/29/1991 and I want the date to show up on the calendar for 01/29/2025, is there a formula that I can input that will change with the years and automatically stay on the calendar?

[@MondayGoalGirl]

There’s a way to make the month and day stay the same each year, but it does need a different setup with separate task columns and a different formula. I’ll be sharing a video soon on a bill tracker that can auto-update for both monthly and yearly bills, reflecting the current year until you change it. Hopefully, that’ll give you some ideas on how to make this work!😊

[@meditationrocks2417]

I'm trying to get my sheet to export the tasks like yours but its not working. Do you have any ideas? I have checked the formula and it should work. Even created the month number that I dint have before.

[@MondayGoalGirl]

please check the calendar date by selecting different time periods. (make sure the month number is matched as well) . Then, verify that the entry date of your task matches the calendar date. Finally, review your formula. at the end of the formula, l put 6, because I left 6 empty cells below each date to show my tasks. I forgot to explain that part. please check your calendar to see whether you have the same 6 empty cells. hope this helps! 😄

[@meditationrocks2417]

@@MondayGoalGirl Yes thank you! made it work now :) thank you so much

[@swscoobysnacks4784]

Where'd you find the image of the word 'monthly calendar'? Google is unhelpful and just keeps showing actual calendars with words of the calendar months like Jan, Feb etc 😅

[@MondayGoalGirl]

I made it in Canva. You can create a free account, and there are many free fonts to choose from. Then download it as PNG and remove the background. 😁

[@swscoobysnacks4784]

@@MondayGoalGirl ahh I was losing my mind tryna find where to get it lol. Thank you for this info!!