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
rachel's avatar
rachel
Steel Contributor

bbsin 

 

I think you will have to change the "Dynamic Calendar" if you want to break event information into different rows.

I attached an example.

 

As for colouring, you can use conditional formatting to do that:

 

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