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, tw...
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!
