Create Easy Yearly Calendar in Excel and Sheets with a SINGLE Formula

Подписаться 2,7 млн

Просмотров 1,1 млн

50% 1

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
In this easy-to-follow video, we guide you through the process of creating a dynamic, interactive yearly calendar using just one formula in both Excel and Google Sheets. This tool is perfect for anyone looking for a customizable calendar template.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/dynamic-cal...
🔑 Highlights:
▪️ Learn to make a yearly calendar that updates with a change in the year.
▪️ Discover how to use the SEQUENCE function for an entire year's calendar.
▪️ Understand the use of the DATE and WEEKDAY functions to identify start dates.
▪️ Improve readability with conditional formatting for better visual appeal.
▪️ Find out how to distinguish different months with color coding.
With this calendar you're able to input the year in a cell and the calendar will update automatically for you. To make the calendar even better I use Excel conditional formatting to color every other month in a different color (MOD function can be used here to identify every other month).
You can also use this Excel calendar in your dashboards. It's interactive and you can combine it with data entry for the year.
00:00 Yearly, Dynamic Calendar in Excel and Google Sheets
00:42 SEQUENCE Function for a Yearly Calendar in Excel and Sheets
02:22 DATE and WEEKDAY Function to Identify the Start date
06:11 Conditional Formatting to Improve Readability for Yearly Calendar
Video on MOD Function: • Excel MOD Function - E...
Playlist for Excel 365 new formulas and functions: • Excel for Office 365 &...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 741

@LeilaGharani 11 месяцев назад

Grab the file I used in the video from here 👉 pages.xelplus.com/dynamic-calendar-file

@jeffdea5278 2 года назад

Your channel is the first and only place I go for Excel help. Everything is so clear and concise. Stuff that used to take me hours to figure out takes ten minutes now. You're a hero in my book!

@elvisosei9766 3 года назад

Anyone ever told you.... "You r the best teacher on the globe?" Keep up the good work. Really appreciate all your efforts.

@LeilaGharani 3 года назад

That's really kind! Thank you for watching and commenting.

@somesh2345 3 года назад

Liela create a channel on VBA..🙏

@gim190 2 года назад

I've learnt more about date management in excel in these 10 minutes than in 10 years of no-brain use of it. Thanks!

@navjotsingh2251 3 года назад

Leila, you deserve all the money in the world for helping so many people!!

@uncgoalie 3 года назад

Wow, I just discovered your videos and already watched 4 today - super helpful and extremely well done! Thank you!

@bobjunior3421 Год назад

I have been watching many excel help videos, your teaching is the most clear and understandable! I really appreciated! From now on, I will keep on watching your videos! Love it!

@kaip.5119 3 года назад

Awesome, didn't know that this is possible with only one function. Thanks for sharing and for your amazing teaching skills!

@larslooperman6400 3 года назад

Oh my. Your beautiful brain is solving so many problems that I use to solve by excruciating sessions trying to learn special skills in Excel.

@selianboy8508 2 года назад

I have soooooo much to learn in life... and only fewer than about 30 years to learn it in! Every time I watch your videos and other such on You Tube, I realise that I know nothing! Many thanks...

@theosalt1 2 года назад

It is just so simple to understand after playing it over 20 times slowly. Thank you.

@krn14242 3 года назад

Love it Leila. What a difference from creating calendars dynamically in the past. Thanks for the great video as always.

@LeilaGharani 3 года назад

Thanks so much! 😊

@joshuadooley181 2 года назад

I am going to start binge watching your Excel and PowerPoint videos! You are awesome! Thank you!

@NaveenTamtaIamExcelVBA 3 года назад

You are So inspirational Leila... God Bless You!!!

@antoniogarrido3058 3 года назад

Really useful, Thanks again Leila!! Amazing O365 improvements!

@danzirulez 2 года назад

Loved the music in the end - Relive uses exactly the same tune :) Joke aside, Leila taught me to use excel more efficiently in a few videos than what I learned since Office 2.0 in 1996 or something! Another excellent and simple video! Thank you

@gracemark5995 3 года назад

this is incredible . i never knew that excel can have a calendar with just a formula o.my.god thank you so much leila . you put a lot of effort on these tutorials proud of you . wow 👍👍

@LeilaGharani 3 года назад

Glad you like it, Mark!

@gracemark5995 3 года назад

@@LeilaGharani i'm of couse leila

@wrexxy49 3 года назад

I’ve never learned from someone who explains themselves so clearly. Thank you Leila!!

@LeilaGharani 3 года назад

Glad it was helpful! Thank you.

@sawaimalhi8439 3 года назад

I have some questions about excel and power bi what is carrier level of excel and power bi ..What is level required to got job on these two technology's iam already 1 year experience in excel but I idea what I can do for got job in Karachi Pakistan or others country please suggestions me leela or any one

@somesh2345 3 года назад

Liela create a channel on VBA..🙏

@RZA12 7 месяцев назад

You're the best Leila! Thank you for teaching us in a great way 🙏

@AP-eb8hd 3 года назад

What I really like about this & other video of yours is that the learning one gets. More than the main concepts there are minor things e.g. conditional formating nuances etc.. in this one. Very well done !!

@LeilaGharani 3 года назад

Awesome, thank you!

@ManojKumar-sk3fw 3 года назад

Thanks for this channel. I recently started learning excel in.my old age. And I am sure I will soon become pro in excel by seeing your channel tips and sessions on excel. This is helping me a lot in excelling in my job. Thanks for becoming an idol for old age learning students who somewhere struggle with new generation on these new tricks.. AGAIN THANK YOU VERY MUCH FROM THE CORE OF MY HEART..YOUR SUGGESTIONS ARE HELPING ME IN EARNING MONEY..

@venkatiyer7459 3 года назад

Amazing .. watch any number of times ... your learning skill is excellent ... a big thank you again

@nathanbowers1761 3 года назад

Nicely done, Leila! Easy to follow, logical, and articulatley presented. Thank you.

@LeilaGharani 3 года назад

Glad you enjoyed it, Nathan!

@jeceva09 3 года назад

I always thought it was very complicated to make an excel calendar. But you showed in this video that there is a very simple and easy way to create the calendar. Thank you Leila.

@LeilaGharani 3 года назад

You're very welcome, Jean!

@edgy1rocks 2 года назад

OMG, I'm an old guy and this was like drinking from a fire hydrant! It really helped when I updated my version of MS Office! This stuff is fantastic! Thanks so much!

@KCRippstein 3 года назад

Thank you so much for this! You are seriously the best!

@Oprimaita 3 года назад

Whenever I watch your video, whenever I learn something new. Thanks a lot Leila.

@LeilaGharani 3 года назад

Happy to hear that!

@tonyalas2103 2 года назад

I am humbled by your knowledge and motivated to learn more. Thank you!

@andrewmoss6449 3 года назад

Yeah, it’s amazing how much you can do in one cell now. With the addition of the LET function as well, you can do a lot more with a lot less.

@LeilaGharani 3 года назад

Very true Andrew....

@amaher79 2 года назад

Leila your videos are truly great and are helping me a lot. You make everything super easy.... A big thank you

@yoliedepaz3340 3 года назад

Your voice is very soothing and pleasant to the ears! You’re a very good teacher and trainer. Wow! More power! 👏👏👏

@yoliedepaz3340 3 года назад

Hi Leila, do you have videos which may be helpful in monitoring stocks in excel? Thanks a lot in advance.

@grantstemmet606 Год назад

You explain very clear and at pace anyone can keep up with, thank you from a Newbie.

@laviniaflorea5369 3 года назад

Thanks Leila! My day is not complete if I don't learn something from you! :)

@AbhishekTripathidce 3 года назад

It’s really nice and time saving, Tank you Leila

@63Hash 2 года назад

This is brilliant, Thanks... They say "imitation is the highest form of flattery", so I used your ideas here to create a single month view where the user inputs the year but also selects the month (in a separate cell) using a simple form spinner set from 1 to 12. I also used conditional formatting to get it to place a border around / make bold today's date. I'm very pleases with the result

@notorioussamurai1671 6 месяцев назад

WOW! This seems like what I am looking for, could you guide me if I can do weekly planning of resources of vehicles like this? So the user could click between weeks but still input information mainly in current week?

@ashishmishra2246 3 года назад

Stumbled upon this video today. It didn't take much time after watching the video to subscribe. Thanks for this so interesting and informative video.

@nevermind4780 3 года назад

I always like your innovative way of thinking for using functions and formula

@rollingpanda4198 3 года назад

WOW! This is awesome! So many calendars I've made over the years that were a lot more manual. Thank you!

@LeilaGharani 3 года назад

You are so welcome!

@ramakrishnabalijepalli3721 3 года назад

This is simply a great way to create a calendar which was frustrating till now. Your presentation is awesome. Thank you so much!

@LeilaGharani 3 года назад

Most welcome 😊

@m.raedallulu4166 3 года назад

Smart as usual, Leila Thank you!

@Mymusicfmw33 3 года назад

Wish I found your videos a lonnng time ago. I’ll be retiring soon but always want learn. Your video are great for everyone-non power user and power user alike. Stay well.

@drbahsha 3 года назад

THANK YOU SO MUCH!!!! Excellent presentation...!!! You are a great teacher!!!

@DanKnight 3 года назад

Brilliant! I honestly had my doubts that you could do it with one formula....but I had never used the Sequence function before: thanks for introducing me to that function. Plus the use of multiple conditional formatting rules to add dynamic formatting was a very sweet touch.

@JeremyMcMahan 3 года назад

Fantastic tutorial. I learned several new things on this one. Thanks again Leila!

@LeilaGharani 3 года назад

Glad it was helpful!

@rahulsosonawane 3 года назад

Brilliant Trick! Many Thanks Wish you be always Healthy & Happy:)

@richardralph 2 года назад

Genius. Such brilliantly constructed videos too.

@venkatiyer7459 3 года назад

I watched the entire video and the last few frames were good to hear since I am using Excel 2019 . I practiced the same in google sheet.. thanks

@j.ballsdeep420 2 года назад

There were multiple banners explaining it's in 365 including online but glad it made sense eventually. I'm annoyed MS doesn't allow some functions like queries in online 365 but doesn't in 2019, but that's a different conversation

@chrishaselden 3 года назад

Wow, amazing. Thank you for the video.

@theedspage 2 года назад

These tutorials are amazing, thank you.

@gerardlunow567 3 года назад

Why does anyone give it is thumb's down. I should stop by once a week. I needed this calendar. Thank you!

@LeilaGharani 3 года назад

Thanks for stopping by now!

@srpvneto 3 года назад

Eu achei bem inteligente esta maneira de gerar um calendário. Eu já fazia algo parecido, mas os dias da semana na parte superior do calendário se adaptavam aos dias... No seu calendário os dias sempre ficarão na ordem Dom, Seg, Ter, ..., Sex, Sab e as datas irão se adaptar a eles... Parabéns.... Bem pensado!

@user-fi6sb6ey1c 3 года назад

I’ve always loved Excel really , but all the tricks I learned from you add much flavours to it!!! Thank you

@LeilaGharani 3 года назад

Glad it was helpful! Thank you.

@N7eptune 3 года назад

Super! Thank you Leila.

@stevet3331 3 года назад

Thank you Leila. A great formula update to create a yearly calendar, with a nice CF for the different years.

@LeilaGharani 3 года назад

You're very welcome, Steve!

@shizmosaic 2 года назад

You change my life on a weekly basis!

@ppst817 Год назад

Thank you very much. I learn a lot from your tutorials.

@jamesstubbins3510 2 года назад

Great video it works, I have added Week No. by entering in cell I5 =WEEKNUM(F5,21) then paste in to column

@meseahunt 2 года назад

thanks Leila, smart info from a beautiful teacher!!

@KostasPanagias 2 года назад

Great tutorial! Thanks for sharing this with us!

@BetterSheets 3 года назад

I never heard of the Sequence function until a week ago and now I see it everywhere. Its sooooo useful.

@LeilaGharani 3 года назад

It really is :)

@pepibravo Год назад

Muchas gracias! era exactamente lo que estaba buscando :)

@1guggie 3 года назад

Thank you for creating these videos. I continue to find something new to use everyday. My company uses the "Any Year Monthly Calendar" that is found in the templates. My question is: how can I set it up to send out an email notification to my group, each time I update the calendar? Thank you in advance, and keep up the great work.

@praveenk1672 3 года назад

Excellent video. Will definitely make use of this in project

@NandaKumar-vg9oy 2 года назад

So handy and step by step explanation. Thanks for sharing

@rubenghiragossian2311 3 года назад

Thanks a lot...you are wonderful!

@charlesnazare7358 3 года назад

Awesome Leila! This is really helpful. Your style and explanations are excellent!

@LeilaGharani 3 года назад

Thank you so much, Charles!

@mytwocents9974 2 года назад

I added two features. =B5:H57 < TODAY() Strikethrough - all past dates =B5:H57 = TODAY() Font Color Red - Makes today's date Red As always you give me great ideas.

@jacquiambrose 2 года назад

I am a super novice...but managed to do the calendar following the steps closely. Please may I know where in the formula to add your formula for this extra feature please?

@talibhussainraja7767 2 года назад

@@jacquiambrose conditional formatting

@jesusaburtocruz2217 3 года назад

Excelente trabajo, soy un apasionado de los calendarios

@pablobentancur3948 3 года назад

Great video Leila! I'm a big fan! I added a row next to the calendar which contains the weeks (W1-W52). I've tried to use xlookup and index match in other cell, to obtain the week of the day that I want to know but I can't! Any suggestions? Thanks a lot! All your work is amazing, really helpful!

@waqashassan3867 3 года назад

Amazing. You are great. Thanks for sharing. 😊

@user-km2xs9xl3n Год назад

wow! Brilliant!! Thank you so much

@angufibodavid4031 2 года назад

Thanks a lot. May you live longer. I have learned a new trick from you and I'm going to try it with my students coz I'm an IT Trainer at Saipali Institute of Technology and Management here in Uganda.

@lalitbhandary8457 9 месяцев назад

just love the way you explain. cheers

@winxcelbliss Год назад

Leila Ma'am you are brilliant...

@desipindu420 3 года назад

Fab video. Very useful. Thanks.

@vida1719 3 года назад

Leila, that's an amazing idea to apply dynamic arrays to generate calendar! Great great application of dynamic arrays!

@LeilaGharani 3 года назад

Glad you think so!

@alcxander 2 года назад

every time the videos teach me something! good work!

@dlep9221 3 года назад

Excel is a tool very powerful and you are a very powerful teacher :-)

@pardeeparya9986 3 года назад

Thanks liela. Thanks again.

@manuelquintino3822 3 года назад

Excelent Teacher Ms Leila. I am a Teacher too and i would love to be as good as you. With your simple explanation i made a automated sheet that each monthly took +- 30min to configure. Now I only need less them 10 sec. Wonderfull!...

@LeilaGharani 3 года назад

Wow, thank you Manuel!

@abdulrenishr 3 года назад

I think I need to ask some specific examples. A form to enter dynamic, drop-down, like data as we do in other GUI prog langs. Encryption concept etc. And Ur PPT n xls are becoming a real reference tutorial. Thnq

@silverlicious2086 3 года назад

Nice job. Thanks for the formula.

@satyakamchawla7261 3 года назад

Awesome.....Thanks for sharing

@superexplosiva2001 2 месяца назад

So helpful!

@rory1653 3 года назад

love it! Once again, you have killed it Leila 👏 ♥

@LeilaGharani 3 года назад

Thank you Rory :)

@rabihel-habta313 3 года назад

you are amazing !!!!! thank you so much :)

@ExcellentDude 3 года назад

Thanks! Really great information as usual - added this calendar hack to my bag of tricks.

@LeilaGharani 3 года назад

Great! Hope it'll come in handy.

@neildoc64 2 года назад

Brilliant as always - thanks :)

@DougHExcel 3 года назад

Nice use of SEQUENCE, love these dynamic array functions!

@LeilaGharani 3 года назад

Many thanks Doug!

@mi98joni 3 года назад

Brilliant as always! Love your videos. Keep it up 😊

@LeilaGharani 3 года назад

Thanks so much! 😊

@Pongoafp 3 года назад

Thank you so much, Leila

@Aleksandr01234 3 года назад

Awesome, good job and thx a lot

@mohamedaboobackersiddique7322 3 года назад

Thanks! Btw i dont click thumbs up button during the end of video,because i always first hit thumbs up button and i watch.i m confident that your videos never dissappoint.

@LeilaGharani 3 года назад

Thank you for your trust Mohamed.