Dynamic Calendar Google Sheets Tutorial + FREE template

[@PoppinSoda]

1:22 - data validation (attach tiny calendar) 1:55 - add next days (F4+1) 2:55 - add next week (F4+7) 5:24 - days banner 7:40 - sequence (50 numbers) 16:10 - final formula for tasks per day

[@sonalijain868]

You are the best teacher, my first time making a social media calendar and I could not asked for a better teacher then you! Thank you so Much!!!❤❤

[@thinklikeagirlboss]

I'm so happy you liked it! Thank you so much for watching!! 😊👩‍💻✨

[@mordirit8727]

For future reference, 99.9999% of what is done with Mac's "Command" button is doable with Windows' "Control" button, even this. You can just say "command on my mac, control for windows" and be sure that you're hardly ever gonna be incorrect, it's literally the same functionality for everything it does, just a slightly different name because Gates and Jobs liked to fight idk

[@thinklikeagirlboss]

That's great to hear! Thank you so much!! 😊👩‍💻✨

[@akramobada]

​@@thinklikeagirlbossdo you think making or putting down our task or to do list on paper is better than digital

[@emrilbennett8704]

Jobs is commanding gates is controlling

[@thinklikeagirlboss]

Love it! I'll never forget now 😂

[@emrilbennett8704]

@@thinklikeagirlboss haha thank you.

[@cortadojeffersol8287]

I'm definitely subscribing! I've been so interested since that time i saw a tiktok video of aesthetic spreadsheet contents and since then i've been searching for tutorials but it's so hard to find something as detailed as this. You're such a good teacher! Thank you so much!!!! I appreciate you a lot! ✨️

[@renadalmutairi52]

Yes, the ctrl key in Windows selects separate columns or cells👌👌

[@thinklikeagirlboss]

Thank you so much for confirming that!! 😊👩‍💻✨

[@conniepatton9394]

Your tutorial was exactly what I was needing for a 4 week trip that I am taking. Your tutorial was very easy to follow. Thank you! 😃

[@thinklikeagirlboss]

I'm so glad it was helpful!! 😊👩🏻‍💻✨

[@superiornursing1759]

YOU HAVE THE BEST VIDEOS!!!! I CANT THANK YOU ENOUGH

[@thinklikeagirlboss]

That's so sweet! Thank you so much!! 😊👩🏻‍💻✨

[@superiornursing1759]

QUICK QUESTION : I WANT TO ADD A TIME SLOT UNDER EACH DATE, I added =array_constrain(iferror(filter(E$4:E$53,$D$4:$D$53,$C$4:$C$53=G4),),6,1) and the cell doesn’t take the time that says in that cell. I hope this makes sense what am i doing wrong?

[@Shamekaprophetically]

I’ve been looking for a smart calendar tutorial for monthsss!!! This was sooo helpful, thank you so much ❤😢😊😊😊😊

[@thinklikeagirlboss]

I'm so happy you found it useful! Thank you so much for watching!! 😊👩‍💻✨

[@Yagirlkenzie05]

Thank you so much for this! Im using this for college this year as im taking 5 classes and working! I totally needed something like this! Just changed it from Tasks to assignments and dates to due dates! Its amazing so far!

[@thinklikeagirlboss]

I'm so happy to hear you found it useful! Thank you for commenting 😊👩🏻‍💻✨

[@madelinebancroft5910]

This tutorial is absolutely flawless!! Thank you for making it!

[@thinklikeagirlboss]

Thank you so much for watching! 😊👩‍💻✨💕

[@andrewnewcombe1908]

Cant thank you enough for this tutorial. You are a life saver.

[@nicolelepage1]

For anyone with a cromebook, the command button is ctrl. Once you highlight the first column, hold the ctrl button.

[@thinklikeagirlboss]

Thank you!! 😊👩‍💻✨

[@willyoctavianus8691]

This video is so underrated. So d*mn good! I thank you

[@thinklikeagirlboss]

That's so sweet, thank you so much!! 😊👩‍💻✨

[@MairaFaidz]

THIS IS GENIUS

[@thinklikeagirlboss]

Thank you!! 😊👩🏻‍💻✨

[@lauras616]

You're a GENIUS!!!! Thank you! This is exactly what I needed!!!!

[@thinklikeagirlboss]

That's so sweet! Thank you!! 😊👩‍💻✨

[@gracesss1272]

Hi, I truly cannot thank you enough for your amazing videos. I did your habit one a couple of months ago and it is working amazing! I was in desperate need of a calendar since uni is starting but I cannot use notion or anything else for the life of me, and I don’t like how every other calendar has the time grid embedded in it. And then I found your amazing video! It saved me! Thank you so much!!!

[@thinklikeagirlboss]

Wow thank you so much for your comment! I loved reading this! I'm so excited you found them useful 😊👩‍💻✨

[@ggbiconstructionandsupply3402]

You deserve a whole lot of subscriptions! Lifesaver! Thank you so much!

[@thinklikeagirlboss]

That's so sweet! Thank you so much!! 😊👩‍💻✨

[@JASONBAILEY-m2d]

Very helpful and saved me a ton of stress! Thanks

[@thinklikeagirlboss]

I'm glad it helped! 😊👩‍💻✨

[@marileecruz]

What a great tutorial!!! THANK YOU VERY MUCH! I'm am here for your other videos!

[@thinklikeagirlboss]

Thank you so much!!! 😊👩🏻‍💻✨💕

[@alphamail8974]

Thanks so much for this! I'll eventually buy one of the templates, but I also wanted to learn how to do it myself. Now I can!

[@thinklikeagirlboss]

Thank you so much! I'm so excited you followed the tutorial! 😊👩‍💻✨

[@quietstorm3254]

Thank you Ma'am...I'm the happiest right now feeling accomplished that I followed along and didn't give up when I thought I messed up. Been wanting to make tasks in calendar style for the longest and you're the only one that I see do it in this style. So thanks again for all the tutorials. I'm a fan!

[@thinklikeagirlboss]

Hi! I'm so happy you like my videos, I've noticed you commenting on several of them thank you so much!! This motivates me to keep on making them 😊👩🏻‍💻✨💕

[@quietstorm3254]

@@thinklikeagirlboss I’m binge watching your whole channel. I love the way you explain your steps short and simple. I’m having so much fun organizing on spreadsheet now. I usually preferred writing things down on printed charts, but not no more! lol

[@thinklikeagirlboss]

I'm so excited to hear that!! Thank you SO much! 😊👩‍💻✨💕

[@vikkiadkinson8241]

OMG you made this so so so so so simple and easy to understand!! Thank You! I felt like i was in my old computer programming class for a little bit, LOL. GREAT WORK!

[@thinklikeagirlboss]

Hi! I'm sooo happy you liked it! Thank you so much for watching!! 😊👩🏻‍💻✨💕

[@sandrang2129]

Brilliant, thank you so much!

[@bkjorgenson]

Exactly what I needed. THANK YOU!!!!

[@U-V-F]

I've been looking for this formula for weeks now. Finally I was able to fix my calendar so It could get the data from cells in another sheet. Thank you for sharing!!!

[@thinklikeagirlboss]

I'm so happy it was useful! Thank you so much for watching!! 😊👩‍💻✨

[@GabbyShisler]

If you don’t mind me asking, how do you get the data from another sheet??

[@birasaclarisse4325]

thank you so much for this tutorial .it was easy to apply it now, I manage to create my own calendar.Keep up

[@thinklikeagirlboss]

Thank you for watching!! 😊👩🏻‍💻✨

[@danielscott1603]

Amazing video!! Learnt lots of little tricks, great work!

[@laurinpatton]

Loved this tutorial !!! Thanks so much for sharing.

[@thinklikeagirlboss]

Thank you for watching and commenting! I'm so happy you liked it! 😊👩🏻‍💻✨

[@thanhhuynhtan7988]

Thank you for sharing this tutorial! This is amazing. I love it so much!!!

[@PalakGarg-yv1qk]

LOVE IIITT, will make me more organised definitely

[@vendea8724]

Just used it. Thank you so much! This is so useful.

[@thinklikeagirlboss]

I'm so glad you found it useful, thank you for watching! 😊👩🏻‍💻✨

[@luserranita]

Thank you so much! i own a small bussiness and had been looking for a way to view my orders in a calendar which used the data of my google sheet for ages!! I didn't know it could be done this way!!

[@thinklikeagirlboss]

I'm so happy you found it useful!! Thank you for watching! 😊👩‍💻✨

[@reenajohn3462]

My Calendar came out beautiful..... Thank you for such easy & clear instructions..

[@lyra8529]

Your explanations were so clear and informative (esp. on the commands)! I've never touched or made anything on google sheets but i was able to follow through without a problem.

[@thinklikeagirlboss]

I'm so happy you were able to follow along!! Thank you so much for watching!! 😊👩‍💻✨

[@shreyas.explains]

You are a Life Saver

[@kensioson1644]

I loooove this so much. Thank you for making tutorials!

[@thinklikeagirlboss]

Thank you so much for watching!! 😊👩‍💻✨

[@desbullard26]

This was EXACTLY what I needed after struggling to figure out how to do what I wanted to do - thank you!!

[@Ron-io1hh]

Bravo - best tutorial ever.

[@thinklikeagirlboss]

Thank you SO much!! 😊👩🏻‍💻✨

[@RositaAntoni]

Life saver! Thank you.

[@thinklikeagirlboss]

I'm glad it helped! 😊👩🏻‍💻✨

[@th_3931]

I thought I'd never be able to learn how to work on a spreadsheet, thanks for proving me wrong

[@thinklikeagirlboss]

I loved reading this thank you so much for watching!! 😊👩‍💻✨

[@scruzromero]

This was amazing. I knew there was a way of doing this, but didn't know how. Thank you!!! :)

[@kayssayoanna22]

thank you this was the best and it was super fun and easy to understand i cant wait for more of these videos it very fun

[@thinklikeagirlboss]

I'm so glad you enjoyed it! Thank you!! 😊👩🏻‍💻✨

[@febriasarela]

Thank you! I found it so useful!

[@iLoveGD-ru3xq]

I love all your tutorials, Thank you for sharing ❤

[@thinklikeagirlboss]

I'm so excited to hear that! Thank you for commenting!! 😊👩‍💻✨💕

[@denineblevins2141]

Whoa this was the first video that popped up on my search and is exactly what I needed! I can’t wait to try it tomorrow.

[@thinklikeagirlboss]

I hope you like it! 😊👩‍💻✨

[@Maya-1302]

Thank you 💜💜This has helped me so much

[@chrischoi1648]

Amazing tutorial. Thank you so much for sharing. Easy to follow and will be using it in my daily organization.

[@elizabethrcrandall6877]

This was sooo helpful, thank you! It was just right, not to easy, not to hard, I just had to slow it down a little!

[@thinklikeagirlboss]

I'm so glad it was helpful! Thank you so much for following along! 😊👩🏻‍💻✨

[@Pop73-mac]

I really appreciate this video, it is informative, easy to follow and actually teaches us rather than a magic jump.

[@thinklikeagirlboss]

I'm so happy you liked it! Thank you for watching! 😊👩🏻‍💻✨

[@DanielOrzano]

Your video tutorials is always a new and beautiful discovery that I can put into practice the next day to improve my work in the office. The only change I made is to write the names of the days in Italian, because I'm Italian, but it was already perfect like this. Thanks again.

[@thinklikeagirlboss]

Thank you so much!! I'm so happy you find them useful 😊👩🏻‍💻✨

[@mariam-mona]

Wow very helpful, thank you so much !!

[@JonathanScott-r7o]

Loved this, very well detailed and very easy to follow, loved how you explained how the formulas worked as well.

[@thinklikeagirlboss]

I'm so happy you liked it!! Thank you! 😊👩‍💻✨

[@maryamfama]

really helpful, easy to follow the instructions. thankyou so much

[@thinklikeagirlboss]

Thank you for watching! 😊👩‍💻✨

[@miguellosada623]

So useful! Thanks !!

[@oluwabunmiayodeji4535]

Thank you so so much. I was able to follow your instructions and I created mine. Thank you so much.

[@DimpleNicdao-s3f]

You are by far my favorite google sheet instructor! Your tutorials are organized, clear and informative.

[@thinklikeagirlboss]

It's so amazing to read this! I'm honored! Thank you so much!! 😊👩🏻‍💻✨💕

[@DimpleNicdao-s3f]

@@thinklikeagirlboss Yay to girlpower! 😘

[@dcon1234]

So helpful, just what I am looking for! 🎉

[@thinklikeagirlboss]

I'm glad you liked it! Thank you for watching! 😊👩‍💻✨

[@jacintagrant2536]

I LOVE this. It was easy to follow and easy to apply to other templates. Very informative and very useful. I'm trying to be more organized this semester and I am so grateful that I came across this. Thank you so much for doing what you do.

[@thinklikeagirlboss]

I'm so happy you found this useful! Thank you so much for watching and I wish you the best in this new semester! 😊👩‍💻✨

[@HaterSinceDay1]

As someone who struggles with following tutorials this was the easiest tutorial to ever follow! New Subscriber Here

[@thinklikeagirlboss]

I'm so happy to hear that!! Thank you so much for commenting! 😊👩🏻‍💻✨

[@CherBeng]

Thank you for this! I made one and it's so convenient to use.

[@knowfact_noshit1972]

super easy! loved it.

[@taznaf5978]

this was amazing thank you so much!

[@oriberlad9759]

thank you great help

[@IrinaTsymbaliuk]

This is super useful! Thank you!

[@thinklikeagirlboss]

I'm glad you found useful! Thank you for watching! 😊👩🏻‍💻✨

[@sdmagic]

That was wonderful. I learned a lot! Thanks!

[@CassyJudith]

Thank you for this amazing tutorial. Can not wait. to watch your other tutorials

[@CynthiaGuajardo-z2w]

Thank you so much for this video!

[@thinklikeagirlboss]

Thank you for watching!! 😊👩🏻‍💻✨

[@mreighties2860]

I have added this tutorial to my other calendar tutorials. Thanks for sharing and it was a joy to follow along and create this calendar. James :)

[@thinklikeagirlboss]

I'm so happy you enjoyed following along! Thank you so much for watching! 😊👩‍💻✨

[@y0u5uf]

Really Enjoyed that and very useful. Thank you.🙂🙂

[@thinklikeagirlboss]

Thank you for watching!! 😊👩‍💻✨

[@Alphaplayersyt]

Just awesome..all your work out here..is just too good Subscribed.. from India

[@thinklikeagirlboss]

Thank you!! 😊👩🏻‍💻✨

[@ayajumah]

great and creative one!! thank you!!

[@thinklikeagirlboss]

Thank you for watching!! 😊👩🏻‍💻✨

[@DaBoogeyman92]

Amazingly well explained thanks a lot !!!

[@DianaTaylor-t7z]

Thank you so much for such detailed step by step tutorial! Very lucky to discover your KZbin channel here. It made my holiday planning so much easier!

[@thinklikeagirlboss]

I'm so happy to hear that! Thank you for watching! 😊👩🏻‍💻✨

[@carlgrigson824]

It was perfect for a complete novice like me. Thanks!

[@thinklikeagirlboss]

I'm so glad to hear that! Thank you so much for watching! 😊👩‍💻✨

[@methodagency]

this is incredible ! you are spreadsheet goals :)

[@thinklikeagirlboss]

That's so sweet! Thank you so much!! 😊👩🏻‍💻✨

[@eadreyuh]

MacBook's command = Ctrl + Windows; that's what she did on Columns A and E (Time stamp 6:51).

[@KingTitanIII]

This was an awesome experience.

[@thinklikeagirlboss]

I'm so excited to hear that! Thank you so much for watching! 😊👩‍💻✨

[@a.sassenach]

Thank you so much!! Your tutorial helps a lot!!

[@monicahampton5938]

Thank you for the tutorial and the extra formatting tips.

[@thinklikeagirlboss]

Thank you for watching! 😊👩🏻‍💻✨

[@WM-cl6kq]

Great tutorial, Thumbs up!

[@thinklikeagirlboss]

Thank you so much!! 😊👩🏻‍💻✨

[@eveygay4746]

wow! Love the tutorial❤

[@thinklikeagirlboss]

Thank you!! 😊👩🏻‍💻✨💕

[@gustavolutz6846]

You are amazing, great tutorials!

[@thinklikeagirlboss]

Thank you so much!! 😊👩🏻‍💻✨

[@charlenestewart7395]

This was awesome!!! Thank you

[@thinklikeagirlboss]

Thank you for watching! 😊👩🏻‍💻✨

[@ajiketpal1602]

Thank You. You're a life saver. I have been searching for a good tutorial and finally found yours. Now I can even tweak it for my own personal need. Again Thank You 😉😉

[@thinklikeagirlboss]

Thank you for watching! 😊👩🏻‍💻✨

[@valentinam3224]

Thank you so much! There's not many aesthetically pleasing sheets calendars out there, hopefully this'll help me with my studies! Also learnt a lot of excel!

[@thinklikeagirlboss]

I'm so happy you liked it!! Thank you so much for watching and commenting! 😊👩🏻‍💻✨

[@najwarahmatia496]

I'm using windows rn. For the Ctrl key is actually worked! Thank you for ur information! Also for ur tutorial its help me a lot to organized anything! KEEP GOIN BABEEE 💗💗💗💗

[@thinklikeagirlboss]

I'm so happy you liked it! Thank you so much for watching and commenting! 😊👩‍💻✨💕

[@BOREYKROUYEUNG]

So useful Love it, I can do it from ur VDO ,Thx so much

[@thinklikeagirlboss]

I'm so happy to hear that!! Thank you so much for watching!! 😊👩‍💻✨

[@gayatrisetty7]

THANK YOU, you do not understand how much finding this video means to me, i have been searching for a tracker app or temple for a few days because this is EXACTLY what I wanted but I didn't know how to make it and all the apps were to complex, YOU ARE AMAZING THANK YOU SO MUCH ♥♥♥♥♥♥

[@thinklikeagirlboss]

Hi! Thank you so much for watching and taking the time to comment! I'm so happy you found it useful! 😊👩🏻‍💻✨

[@ItsSimplyPhina]

This was incredibly helpful and easy to follow. Thank you ❤

[@thinklikeagirlboss]

I'm glad it was helpful! Thank you for watching! 😊👩🏻‍💻✨💕

[@everlastingideas8625]

Thank you for this tutorial this was extremely helpful

[@kriszzzz6155]

love watching your tutorial videos, Never get bored. Thx so much for sharing

[@thinklikeagirlboss]

I'm so happy to hear that! Thank you so much for watching them! 😊👩🏻‍💻✨

[@mollyy7356]

Great video! Love this!❤

[@thinklikeagirlboss]

Thank you!! 😊👩‍💻✨💕

[@Kay_McRae]

This was awesome!! It looks great and was so easy to follow. Thank you so much!!

[@thinklikeagirlboss]

Thank you for watching!! 😊👩‍💻✨

[@Tamizhamudhini]

Awesome video. Thank you!

[@gracefulgritqueen]

It was control on the Windows thank you for that. And this whole tutorial.

[@thinklikeagirlboss]

Thank you so much!! 😊👩‍💻✨

[@FressieLynn]

THANK YOU! I HAVE LEARN SOME NEW!

[@thinklikeagirlboss]

I'm so happy to hear that! Thank you for watching! 😊👩‍💻✨

[@ColeJohnson-rs6mc]

Thanks for this!!

[@nicfergus]

Very clear and informative instructional... Thanks! 🔥

[@thinklikeagirlboss]

Thank you for watching!! 😊👩‍💻✨

[@shoto6329]

hey, thank you so much for this. it was easy to follow and now, I have a calendar in sheet! thank you!

[@ashmersetty2764]

Great!!!! This changes my whole organzing game thankss alottt👍🏽👍🏽