Convert a List of Events into a Graphical Calendar in Excel

[@BarryScullin]

Thank you for the video. I have a question. How do you eliminate duplicate information, so it only appears once in the calendar? Then taking it a step further, how do I incorporate multiple sheets into the one calendar?

[@laurencehartigan9777]

How can I start the week on a Monday? Thank you in advance.

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

[@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?

[@VeronicaSanchez-qt1zf]

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?

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

[@woofready5390]

So easy to follow thank you

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

[@Herocooper1111]

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

[@ExcelU]

I’m releasing a video that demonstrates that this Wednesday :)

[@ihavethepowerquery4718]

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

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

[@ExcelU]

The formatting applied to the cell (left/right alignment) doesn't impact the functions :) The functions operate on the stored value, regardless of formatting.

[@kimsadowski4058]

@@ExcelU thank you!

[@PaulEBrownbill]

Thanks Jeff, great as always. Paul

[@BigD63]

Great info ... Thanks Jeff

[@WavzonRox39]

Excellent!

[@johndurran614]

Excellent