Excel calendar with just one formula (dynamic for all years) 📅
► Subscribe to the channel: https://bit.ly/lobilution
Here you'll learn how to create a dynamic yearly calendar in Excel with just one formula that adapts to each year and also highlights the current date in color. The same formula also works in Google Sheets. However, you'll need Office 365, as you'll need the SEQUENCE function. We'll also use the WEEKDAY and DATE functions. Have fun learning! :-)
▬ My Equipment & Tips ▬▬▬▬▬▬▬▬▬▬▬▬▬
In the video:
► * Learn Excel: https://amzn.to/3ku1yFr
► * Microphone: https://amzn.to/3CX3XyP
► * Software: https://amzn.to/3ZIAUZE
► * Video Editing: https://amzn.to/3iGP2SF
If you need a break from Excel:
► * Balance Board: https://amzn.to/3ZRDE74
► * Blackroll: https://amzn.to/3H6ibyO
► * Theraband: https://amzn.to/3J6UMQ9
*Thank you for your free support through these affiliate links!
▬ More Videos ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
► Excel: Highlight entire row if | Conditional Formatting
https://www.youtube.com/watch?v=n6j8k...
► Excel - Combining IF AND OR functions - explained simply:
https://www.youtube.com/watch?v=Ucdfr...
► Excel: Checkboxes:
https://www.youtube.com/watch?v=PY7Tv...
#excel #office365 #calendar