I have a three columns for 2018 Holidays :
Subject Start Date End Date Weight Loss Awareness Month 1/1/2018 1/31/2018 National Blood Donor Month 1/1/2018 1/31/2018 National Hobby Month 1/1/2018 1/31/2018 Golden Globes 1/7/2018 1/7/2018 Girl Scout Cookie Season Begins 1/1/2018 1/31/2018 Diet Resolution Week 1/1/2018 1/7/2018 Hunt For Happiness 1/4/2018 1/20/2018 New Year's Day 1/1/2018 1/1/2018 Trivia Day 1/4/2018 1/4/2018
I'm trying to use the following formula to return a list of "active" Holidays between two dates.
=IFERROR(INDEX(Holidays,MATCH(1,(start_dates>=T$5)*(end_dates<=X$5),0)),"")
The start date in this example would be 12/27/2017 and the end date would be 1/3/2018.
Appreciate your consideration.
Bookmarks