Forum Discussion
Community event planner calendar template
Hi Ana,
Template compares for each calendar date if such date is in Dates range which is actually the DATE column in the event table.
What you need to if to compare if calendar date is between Dates and EndDates. For that add named range ENDDATE which is EndDate column of the event table and use array formula
=IFERROR(INDEX(tblEvents,SMALL(IF((Dates<=L$11)*(ENDDATE>=L$11),ROW(Dates)),ROW(1:1))-TableRowStart,4),"")
The only difference with initial one is using of
(Dates<=L$11)*(ENDDATE>=L$11) instead of (Dates=L$11)
After that formula is to be copied on each empty cell within calendar date block and for all dates for the same week.
For other week the formula is to be adjusted (e.g you have to change L$11 on L$6 for upper date).
Same way for entire calendar.
In the attached file i did that for few days, not for all of them.
Hi Ana,
Template compares for each calendar date if such date is in Dates range which is actually the DATE column in the event table.
What you need to if to compare if calendar date is between Dates and EndDates. For that add named range ENDDATE which is EndDate column of the event table and use array formula
=IFERROR(INDEX(tblEvents,SMALL(IF((Dates<=L$11)*(ENDDATE>=L$11),ROW(Dates)),ROW(1:1))-TableRowStart,4),"")
The only difference with initial one is using of
(Dates<=L$11)*(ENDDATE>=L$11) instead of (Dates=L$11)
After that formula is to be copied on each empty cell within calendar date block and for all dates for the same week.
For other week the formula is to be adjusted (e.g you have to change L$11 on L$6 for upper date).
Same way for entire calendar.
In the attached file i did that for few days, not for all of them.
Thank you so much!!
Is there anyway to add a formula that will merge those cells with a start and end date?
Sorry, didn't catch - which cells would you like to merge?
The ones for that event for that time period. For instance if I schedule an appointment in my calendar that event is merged from the start to end date.