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 column as the date and the other for input text
the calendar to dates to move accordingly,  I cannot input a column the date doesnt move..

Please advise. 

col C8 -=SEQUENCE(6,7,0)+DATE($C$4,$K$2,1)-WEEKDAY(DATE($C$4,$K$2,1),2)+1

 


to be like that



Thank you

 

 

    • bbsin's avatar
      bbsin
      Iron Contributor

      hi Rachel

      Thank you is there any way to auto populate the text from any other tab that match the date in the calendar?

      to display eg Title, Category , Start to end date / time.

      Attached sample tab , event data start and end time are from SP which contain Date and Time, but how to use Text Join to match it to the cal date and display across if it run few day?  Thank you

       

Resources