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 ❤

[@arfalitashashikaaira3789]

hello when i try to put the formula link monday & Sunday Start to Calendar it say the formula was error, i reffer to minute 1:39, can you text the formula so i can copy that. Thank You

[@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! 😄

[@viinno]

so cute, love it 🥰🥰

[@Meowkakaw223]

Hi, your tutorial was easy to follow! Just wanna ask if there’s a way to input the task on the calendar itself and it would appear on the task list?

[@MondayGoalGirl]

Yes you can! I will need to make another video for that 😆!

[@Meowkakaw223]

@@MondayGoalGirlis there anyway to incorporate it into this calendar?

[@zoya_anya]

is there a way to reference tasks from a separate sheet? for example, i have my task list in sheet 1 column a, and due dates on column b (also in sheet 1) T_T

[@sokosolongo1577]

1:25 - How did you paint the G row to the M row green?

[@MondayGoalGirl]

I highlighted the row and change the background color to green! Color codes is in the description 😊

[@AmenaElSheikh]

Thanks for this tutorial. I have a slight issue tho. In the month of June, when i change the weekstart to monday, all the dates are gone. When i used the formula you revised in the timestamp 2:15, it comes back but it affects November which it loses the dates too when changed to monday. I checked all other months are working fine. What could be the problem?

[@fayzaputriadila4581]

Hi, I also have the same problem!

[@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.

[@nabilahazahar1283]

Tysm for the tutorial, I love it. but i have a question, why there are months like march & sept have problems i.e. month dates have errors like "function WEEKDAY parameter 1 expects number value. But 'March 2024' is text and cannot be coerced to number"?

[@MondayGoalGirl]

@@nabilahazahar1283 glad I can help! Let me see if I can fix it! 😅

[@favourefiok]

I have the same issues with everything, not just one month.

[@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! 😄

[@georgetteshane]

@@MondayGoalGirl hello there sis, i need it with details of my content for my daily posting, with my graphic content in it, and a dropdown of different social media platform like facebook, instagram, pinterest, tiktok, youtube.. 🙏🙏

[@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

[@iamwinner6543]

Hi I have also tried gettings tasks I have done everything same still not getting the task shown in calender pls help

[@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!😊

[@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!!

[@sofiachudzikbauer7829]

My tasks are not showing on the calendar

[@MondayGoalGirl]

hi, i made a mistake in the formula. the correct formula is in the description. :)