Forum Discussion

bbsin's avatar
bbsin
Iron Contributor
Dec 15, 2023

dynamic excel calendar help pls

hi I saw a youtube to create a dynamic calendar   the dates are using sequence, may I know how to have column D for text input  Mon to Sun same for the rest of the columns I want to have one...
excel
bbsin's avatar
bbsin
Iron Contributor
Dec 18, 2023

rachel 

 

I have tried, but it's not working
How to link it back to the year and month to pull the data, do I still need to use TEXT join?

 

rachel's avatar
rachel
Steel Contributor
Dec 18, 2023

bbsin 

I added Named Range for Year and Month and updated the formula too:

 

 

You don't need TEXTJOIN now. as Event information are displayed in 3 rows using TRANSPOSE.

 

Resources