Convert a List of Events into a Graphical Calendar in Excel 

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?

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

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

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

Thanks Jeff, great as always. Paul

Great info ... Thanks Jeff

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.

Excellent!

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

Excellent