Forum Discussion
bbsin
Dec 15, 2023Iron Contributor
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
- rachelSteel Contributor
- bbsinIron 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