Forum Discussion
Excel Calendar
I am trying to create a calendar that will update content on dates based on what is entered into a separate table. I have a drop down to select month and year, and a separate table with 3 headers, two of which I would like to appear on the calendar.
I am using the following formula to create the calendar:
=SEQUENCE(6, 7, DATE(C3, MONTH(DATEVALUE(B3 & " 1")), 1) - WEEKDAY(DATE(C3, MONTH(DATEVALUE(B3 & " 1")), 1), 1) + 1, 1)
Along with conditional formatting for the dates.
Any feedback on how to do this would be greatly appreciated.
J3-L3 are headers for the table (Name, Due Date, Notes)
I need content Name and Notes to appear on the corresponding date in the calendar (due date).
B3 is the drop down for month, and C3 is the drop down for year.
The calendar starts at B6 (days of the weeks listed B5-H5).
3 Replies
Thanks for sending the workbook. I have attached the modified version.
I had to change the formulas to generate the calendar, and add extra rows.
I have moved the data table to a separate sheet for aesthetic reasons.
Wow. Perfect. Thank you. I tried the =textjoin(char.... couldnt get it to work either. but I did not think of moving the calendar dates to another cell. I was having a lot of issues with date formatting.
Thanks again!
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
