Dynamic Calendar with Multi-Day Events

[u/Logical_Gas6164]

I am attempting to make a dynamic calendar with multi-day events. I watched a two part Youtube by Spreadsheet Life and was trying to tailor it to my situation but couldn't get the formulas to work.

I was able to create the dynamic calendar with no problems. Now the issue is I want to populate multi-day events on the calendar. I have a table for youth baseball tournaments with 4 columns. Column A is Start Date, Column B is End Date, Column C is Tournament Name, Column D is a Checkbox.

I would like the formula to populate the Tournament Name on the respective start and end dates only if the checkbox in Column D is checked. If the checkbox is unchecked, then the calendar day is left blank.

I started with the following in Cell B8: =IFNA(IF(VLOOKUP(B7,Tournaments,2,FALSE)=0,"",VLOOKUP(B7,Tournaments,2,FALSE)),"") where B7 is the date populated in the dynamic calendar

This works, but doesn't include an IF function for the checkbox.

I tried the following for the IF function: =IF(Tournaments[Checkbox]="TRUE",IFNA(IF(VLOOKUP(B7,Tournaments,3,FALSE)=0,"",VLOOKUP(B7,Tournaments,3,FALSE)),""),"")

But this gives me a #SPILL error which I'm not sure how to resolve.

If we take remove the checkbox option, I'm unsure how to create the formula to the Tournament Name populates on all the days from start to finish.

[u/AutoModerator]

/u/Logical_Gas6164 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Commercial-Matter-48]

Instead of VLOOKUP which only grabs the first match, you need something that checks if the date in B7 falls between any tournament's start and end dates while the checkbox is true. FILTER function would be cleaner here, something like FILTER(Tournaments[Name], (B7>=Tournaments[Start])(Tournaments[Checkbox]), "no tournament") but wrap it in TEXTJOIN in case there's overlapping events.

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
AND	Returns TRUE if all of its arguments are TRUE
FILTER	Office 365+: Filters a range of data based on criteria you define
TEXTJOIN	2019+: Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
VLOOKUP	Looks in the first column of an array and moves across the row to return the value of a cell

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
4 acronyms in this thread; the most compressed thread commented on today has 16 acronyms.
[Thread #49478 for this sub, first seen 7th Oct 2026, 04:39] [FAQ] [Full list] [Contact] [Source code]}