Importing Cell Data into Calendar

claybwagner28

New Member
Joined
Sep 25, 2014
Messages
49
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)

1615328003132.png


Hopefully I am overthinking it. :)
Thanks!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Perpa

Well-known Member
Joined
Dec 18, 2012
Messages
635
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
 

Watch MrExcel Video

Forum statistics

Threads
1,129,452
Messages
5,636,340
Members
416,914
Latest member
DWC199

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top