Importing Cell Data into Calendar

[claybwagner28]

Hello,

I have a simple worksheet that has department name, draft due, final report due in columns A,B,C.
Rows 2-14 have the individual departments and the respective dates.
My boss wants a calendar he can print off with these days. I know Excel has a calendar but I have to manually enter the days.
Is there a simple way for excel to populate a calendar with the dates in the respective cells? (Update when cell value changes)

Hopefully I am overthinking it.
Thanks!

 

[Perpa]

Clay,
Do a search on Mr Excel for 'Excel's Magic Calendar' and go to posts 18 and above to see a similar situation to yours. There is a link to a download of that calendar. The dates are added to the correct monthly calendar from the list of dates in column J and the item in column K. The calendar is updated when you change the Month in cell J4. Maybe this will help.
Perpa

 

[claybwagner28]

I will check it out. Thanks!