Hello everyone,
I've got a headscratcher. I have one sheet with a list of people with codes that have a start date and an end date. On another sheet with a list of holidays and black out dates. I need to see if any people from sheet one that have codes on or between the start and end dates during any of the holidays on sheet two and whether or not it's a blackout date and/or a holiday. I have attached a screenshot of each sheet. Ideally, I would like to show the answers to show in column E of sheet 1.
For example: (Sheet 1)
A B C D E
1 102 BCC 3/27/2015 3/30/2015 Blackout Date
2 102 OGG 12/25/2015 12/25/2015 Holiday
3 102 SMF 12/6/2015 12/8/2015
(Sheet 2)
Date Day of Week Holiday Black Out Dates Holiday
1 1/1/2012 Sunday New Year's Day Black Out Holiday
2 1/2/2012 Monday New Year's Day Black Out
3 1/3/2012 Tuesday New Year's Day Black Out
4 1/16/2012 Monday Martin Luther King Day Holiday
5 2/14/2012 Tuesday Valentine's Day Holiday
6 2/17/2012 Friday Predidents Day Weekend Black Out
7 2/18/2012 Saturday Predidents Day Weekend Black Out
I've been trying many kinds of things all week and am at a loss. Any help would be greatly appreciated!
Thank you!
Bookmarks