Convert a List of Events into a Graphical Calendar in Excel

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

Also, check out these videos with time saving Excel Hacks:

[ihavethepowerquery]

Thank you very kindly. Never knew most of this was possible. I am in your debt.

[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!

[VeronicaSanchez-qtzf]

I watched this video yesterday, I created my first calendar yesterday. I love it. Just one question, how about if I want each item to show up on it's own line, instead of one after the other, just separated by comma?

[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. 😊

[millychen]

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.]

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.

[Herocooper]

great calender but how would you add events with a start and end date? i want to create a year calendar that shows all the onsite days for my event staff. a month could have multiple events happening at the same time

[kimsadowski]

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 :)