I have been tasked with putting together a pivot table for my group that will
highlight if a persons vacation falls within blackout dates. Right now I have
a list of names and a start and end date for there vacations. I also have a
list of blackout dates set up with start and end dates. Not sure about where
to start or if this can be done? Below is what I have so far
Tab 1
A B C
1 John Doe 10/1/08 10/8/08
2 Jane Doe 1/2/08 1/9/08

Tab 2
A B C
1 blackout A 1/7/08 1/20/08
2 blackout B 9/28/08 10/2/08

I need to know that John & Jane Does vacation is scheduled on a blackout
date. Any help would be greatly appreciated.