calendar

[jeffmfrank]

I'm trying to create a tool that includes a printable one-month desk calendar. The days need to populate from entries in a list with the fields, "Date" & "Event". Multiple events (up to 12) can occur on the same day, and events will not always be entered in chronological order. Any suggestions on an approach? (A vlookup for date values equal to the day on the calendar seems inadequate since it would need to return multiple entries and the entries are not in order).

 

[Chris Davison]

Hi Jeff,

could a pivot table achieve what your after ? How about a Gantt Chart ? (there's an example in the tip-of-the-day files here on Mr Excel.... something I later used to schedule out my monthly duties and dates at work)

[I assumed it was free] :wink: