I am trying to create a project calendar using conditional formatting and start and end date ranges. I want to take a list of holiday start and end dates and have them fill in on the calendar, but I want all of this information to be in one row instead of on their own individual line.
I have tried the AND formula but it will only work for one set of dates. I tried the MATCH formula, but it is only putting the start dates in the row and I need the entire date range if there is multiple dates.
I greatly appreciate any help or suggestions you might have!
