Forum Discussion
Converting Excel table data into calendar using pivot table
Hi all, Our organization has a long list of upcoming conferences and we're trying to display that in a more calendar-view within Excel. On this thread, many others have the same question and one use...
Hi,
Is attached what you want?
You can change the Month in cell F5 to update dates and events.
Someone shared some Excel formulas he watched on youtube to create a dynamic calendar in below post and I adjusted his template for you.
https://techcommunity.microsoft.com/t5/excel/dynamic-excel-calendar-help-pls/m-p/4009741