Convert a List of Events into a Graphical Calendar in Excel

File Download: www.excel-university.com/yt_v...
This video shows the functions, formulas, and formatting to convert a table of events and dates into a graphical calendar.
Specifically:
- SEQUENCE
- WEEKDAY
- EOMONTH
- ARRAYTOTEXT
- FILTER
- Formula of dates
- Formula to retrieve events
- Formatting
- Conditional formatting to make it dynamic
Chapters in this video:
00:00 - Introduction
00:21 - Exercise 1
02:25 - Exercise 2
05:40 - Exercise 3
🚀 Unlock hidden Excel tricks and hacks, and become a time-saving Excel pro 👉 www.excel-university.com/yt_v... ⚡️🕒 Say goodbye to late nights and spreadsheet struggles!
Subscribe here 👉 czcams.com/users/ExcelUniver... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Also, check out these videos with time saving Excel Hacks:
Excel PivotTables for Beginners • Excel PivotTables for ...
Watch VLOOKUP Hacks Playlist here • VLOOKUP Hacks Series
Watch VLOOKUP vs SUMIFS Playlist here • VLOOKUP vs SUMIFS Series
Watch Dynamic Arrays playlist here • Dynamic Arrays Series
Watch Treasure Maps playlist here • Treasure Maps Series
Watch Slow to Fast playlist here • Slow to Fast Series

[@BigD63]

Great info ... Thanks Jeff

[@nassiriabraham]

This is indeed advanced concept but the way you make it look easy is also another level for me
Thanks for sharing this tips and tricks

[@AudreyFlorence]

Jeff, always, thank you! I've already modified your exercises to fit a recent need at my company!

[@ExcelCampus]

Great video Jeff! I remember creating something similar for a scheduling calendar before dynamic array formulas were released. It was so much more difficult to do back then. Dynamic arrays make life easy. 😊

[@ExcelU]

Thanks Jon!! I agree and am still discovering ways to apply dynamic arrays :)

[@PaulEBrownbill]

Thanks Jeff, great as always. Paul

[@user-mb9mo8ku8w]

Excellent!

[@johndurran614]

Excellent

[@millychen2596]

Is it possible to show the length of the programs? For instance, I have programs that run 4 weeks or 8 weeks or 12 weeks and they all have different start dates. Is there a way to display what programs are running everyday?

[@zanquinoe.s.7131]

Thank you for all the content.
Any tips regarding fixing the “Formula Bar” font changing when displaying a formula?
For example, when you click the CELL the formula bar presents a FONT but when you press the formula bar to make changes the FONT changes making me double click the bar to reposition.

[@kimsadowski4058]

Hi Jeff. Does it matter whether the date is to the left or to the right of the cell with the WEEKDAY of the EOM functions? Many thanks :)