OMG this video was gold, I was looking everywhere for a way to build an automated annual calendar!! I love how you share your knowledge so confidently, it helps a lot! Good job! ✨
Thank you! Some people are asking me for more advanced things and others for beginner tutorials so I will definitely try to do a bit of everything. If you have any other requests I would love to know! 😊👩💻✨ I'll for sure do a more dynamic calendar tutorial next year 😊
this video was recommended by my colleague as we're learning Google Sheets (too late but why not), and I really appreciate and love the way you walked us through this process. Not to mention, Christmas is one of my favourite holidays. 😊 I have learned new stuff and will make sure to watch your other videos. I am a new subscriber!
Hi, can u do a tutorial for calendars starting from Monday, also lined up horizontally and vertically? ( in a box-like format where 3 or 4 months are in a row)
I was going to request this on your other video and then saw this tutorial. You read my mind. Thank you so much for this. I can create a calendar for next year now. Next time, could you also give us the hex codes of the colours? Because those colours are appealing.
thanks so much for this --Questions: how can I keep the task on the calendar without keeping it in cells C and D? Also is there a way to do only certain dates? instead of every date of the month so there's not blank spots?
What do I do if I want to use/copy the conditional formatting for the next months in the next rows so it will look like a whole calendar? Will really appreciate it if you could teach this🥺
Hi! I am just gain interested into using spread sheet for past one month. I want to know how to make the whole 12 month calendar that can dynamicaly change the first day from Monday or Sunday. so may I Ask you to please make that video tutorial. thanks in advance
BTW I followed this method to create a calendar for next year. I followed the above-mentioned method to fill dates. February also adds up to 31 dates. How to limit it to 28 dates without messing with the dates? I used a 3x4 months grid. How to use the conditional formatting for the below months?
Hi! Would you like to share you file with me so I can check it out and see what's up with your dates? You can send me your link privately on Instagram @thinklikeagirlboss 😊👩🏻💻✨
Hi! Thank you so much for this video! :) I'm trying to follow along, however when I do the conditional formatting with "=MONTH(....)MONTH(...)" random dates turn into the format and not the ones that are a different month. Do you have any idea what the issue could be?
Thank you it's very helpful especially to me who doesn't know how to use excel or google sheet but I got a problem with my rules instead the number 30 should be the color red the number 2 was the red one.
Can you do a whole year? Is this also possible if theres an important dates that you are counting down to other than December? Like if i want multiple important dates that you may be looking forward to?
Hi! There's a loooot you can do with calendars so I will keep on making different tutorials that focus on different features, like the one you mentioned 😊👩💻✨
@@thinklikeagirlboss ty so much!! I tried to make this calendar a whole year unfortunately I'm still not good at formatting and stuff so I failed making this a whole year calendar. How do you think I can go about making this into a whole year? Thanks!
You could follow the same steps for formatting the first three months on other rows with 3 months each (treat each row of 3 months as separate from the rest when it comes to formatting), so that would be 4 rows of 3 months each 😊👩🏻💻✨
How do I modify this =K11=$K$5 (highlight christmas day) to a range? Meaning I would like to change K5 to say K1:K5 What i have now is on multiple layers of conditional format rules =K11=$K$1 =K11=$K$2 =K11=$K$3 =K11=$K$4 =K11=$K$5 Hope you can help
Hi! I'm not sure why that is. If you click on FILE then SETTINGS a box pops up for you to select a different country. If you set United States it might show Sunday first 😊👩💻✨
Good day. Thank you so much for the tutorial, really grateful. I do have an issue though. When I got to where I was to automate the first day of the month with the first day of the week and I got lost. You used the formula =O11-(WEEKDAY(K8)-1) because the first day of your week corresponds to 5. For me, the first day of the week corresponds to 6. Tried using the same formula, didn't work. Tried -2, -0, +1, still didn't work. I can't seem to figure out what I'm doing wrong. Please, I need your help. Thank you so much.
Hi! I am planning on making a tutorial covering other start days, I'm sorry I'm taking so long! I have soooo many things I want to create, I wish I could work faster 😊👩🏻💻✨
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
I know Christmas is over, but I enjoy learning your tutorials and here I am learning how to do a 'how many days left' tracker calendar version 😁
OMG this video was gold, I was looking everywhere for a way to build an automated annual calendar!!
I love how you share your knowledge so confidently, it helps a lot! Good job! ✨
I'm so happy you found it useful! Thank you so much for watching and commenting! 😊👩🏻💻✨
I’ve been looking for this video for DAYSSSSSSS
I can't believe you noticed it was gone, thank you!! 😊👩💻✨
This is very helpful and easy. Other videos have been a little too complicated. I would appreciate a video about making a more dynamic calendar.
Thank you! Some people are asking me for more advanced things and others for beginner tutorials so I will definitely try to do a bit of everything. If you have any other requests I would love to know! 😊👩💻✨ I'll for sure do a more dynamic calendar tutorial next year 😊
thank you so much these tutorials are really helpful and fun!
I'm so happy you like them! Thank you for watching!! 😊👩🏻💻✨
Love your videos!! Thank you for this tutorial!❤
I'm so happy to hear that!! Thank you so much for commenting!! 😊👩💻✨🎄
I am loving your videos!! I would love to see a video on making the calendar more dynamic
Thank you so much for commenting! I will definitely make one! 😊👩🏻💻✨
this video was recommended by my colleague as we're learning Google Sheets (too late but why not), and I really appreciate and love the way you walked us through this process. Not to mention, Christmas is one of my favourite holidays. 😊 I have learned new stuff and will make sure to watch your other videos. I am a new subscriber!
Thank you so much for commenting! I'm so happy you found it helpful and it's never too late to learn, keep going!! 😊👩💻✨ Thank you for subscribing!! 💕
You’re brilliant!
Thank you so much for saying that!! I really appreciate it!! 😊👩💻✨
I can't get my days until Christmas to work properly. It is saying January 24, 1900 instead of "70" I am watching this on October 16, 2024.
Hi, can u do a tutorial for calendars starting from Monday, also lined up horizontally and vertically? ( in a box-like format where 3 or 4 months are in a row)
I was going to request this on your other video and then saw this tutorial. You read my mind. Thank you so much for this. I can create a calendar for next year now. Next time, could you also give us the hex codes of the colours? Because those colours are appealing.
Hi! Of course! I'll add them here in a bit 😊 I'm so glad you liked it! Thank you for commenting!! 😊👩🏻💻✨
thanks so much for this --Questions: how can I keep the task on the calendar without keeping it in cells C and D? Also is there a way to do only certain dates? instead of every date of the month so there's not blank spots?
What do I do if I want to use/copy the conditional formatting for the next months in the next rows so it will look like a whole calendar? Will really appreciate it if you could teach this🥺
Hi! I am just gain interested into using spread sheet for past one month. I want to know how to make the whole 12 month calendar that can dynamicaly change the first day from Monday or Sunday. so may I Ask you to please make that video tutorial. thanks in advance
Can you make a tutorial if the start day is monday ?
Absolutely! I will be making one soon 😊👩🏻💻✨
Is it already up? I can't seem to find which one it is on the newer videos @@thinklikeagirlboss
BTW I followed this method to create a calendar for next year. I followed the above-mentioned method to fill dates. February also adds up to 31 dates. How to limit it to 28 dates without messing with the dates? I used a 3x4 months grid. How to use the conditional formatting for the below months?
Hi! Would you like to share you file with me so I can check it out and see what's up with your dates? You can send me your link privately on Instagram @thinklikeagirlboss 😊👩🏻💻✨
I want to start weekday from Monday. what will be the formula then? please help
Hi! Thank you so much for this video! :) I'm trying to follow along, however when I do the conditional formatting with "=MONTH(....)MONTH(...)" random dates turn into the format and not the ones that are a different month. Do you have any idea what the issue could be?
Hi! I'm glad you liked it! Would you like to share your link with me on Instagram (DM) so I can check it out? 😊👩💻✨
Thank you it's very helpful especially to me who doesn't know how to use excel or google sheet but I got a problem with my rules instead the number 30 should be the color red the number 2 was the red one.
Can you do a whole year? Is this also possible if theres an important dates that you are counting down to other than December? Like if i want multiple important dates that you may be looking forward to?
Hi! There's a loooot you can do with calendars so I will keep on making different tutorials that focus on different features, like the one you mentioned 😊👩💻✨
@@thinklikeagirlboss ty so much!! I tried to make this calendar a whole year unfortunately I'm still not good at formatting and stuff so I failed making this a whole year calendar. How do you think I can go about making this into a whole year? Thanks!
You could follow the same steps for formatting the first three months on other rows with 3 months each (treat each row of 3 months as separate from the rest when it comes to formatting), so that would be 4 rows of 3 months each 😊👩🏻💻✨
@@thinklikeagirlboss ty ty I'll try this later and see if it works!
How do I modify this =K11=$K$5 (highlight christmas day) to a range?
Meaning I would like to change K5 to say K1:K5
What i have now is on multiple layers of conditional format rules
=K11=$K$1
=K11=$K$2
=K11=$K$3
=K11=$K$4
=K11=$K$5
Hope you can help
i have a pr0blem my date picker starts with Monday, what should I do?
Hi! I'm not sure why that is. If you click on FILE then SETTINGS a box pops up for you to select a different country. If you set United States it might show Sunday first 😊👩💻✨
Can you make the tutorial if the calendars aren’t aligned?
Yeah! I will be making more calendar tutorials this year 😊👩🏻💻✨ Thank you for commenting! 😊
When I add the day countdown it gives me a date, rather than a numeric value. How do I change this? :)
Hi! you can select that cell and click on FORMAT -> NUMBER and pick a different formatting option 😊👩🏻💻✨
Good day.
Thank you so much for the tutorial, really grateful. I do have an issue though. When I got to where I was to automate the first day of the month with the first day of the week and I got lost. You used the formula =O11-(WEEKDAY(K8)-1) because the first day of your week corresponds to 5. For me, the first day of the week corresponds to 6. Tried using the same formula, didn't work. Tried -2, -0, +1, still didn't work.
I can't seem to figure out what I'm doing wrong. Please, I need your help. Thank you so much.
Hi! I am planning on making a tutorial covering other start days, I'm sorry I'm taking so long! I have soooo many things I want to create, I wish I could work faster 😊👩🏻💻✨
@@thinklikeagirlboss No problem. Thank you so much
❤