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 15, 2023

hi Rachel,
Great it works.

 


. One last question, the text are display as a string of text, is there anyway to break it into next row
event -bold title
confirmed
XXX
add Status :  the data fr the list?

Also anyway to color format the item by it Category?  Thanks

Thank you

rachel's avatar
rachel
Steel Contributor
Dec 15, 2023

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:

 

  • 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.

     

  • 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?

     

Resources