5/10 5/11 5/12 5/13 5/14 5/15 5/16 5/17 5/18 5/19 5/20
A X-1 2 D/O D/O 3 4 5
B 1 X-2 3 D/O D/O 4 5
C 1 2 X-3 4 D/O D/O 5
D 1 2 3 X-4 5
E 1 2 3 4 X-5
F X-1 D/O D/O 2 3 4 5
G 1 X-2 D/O D/O 3 4 5

I have a range of 8 consecutive days.
E.g. 5/11/09 thru 5/18/09
An event happens on one of those days, eg. 5/14 ( see X's)
Employees have 2 days off, e.g. 5/16 & 5/17
I would like the various dates returned showing 5 consecutive days
Event date (X) has to be included, Not including the days off
for all possible scenarios
E.g. Scenario A would return me 5/14 ( the event day) +
5/15,5/18, 5/19 & 5/20
Scenario B would return me 5/13, 5/14 (event day), 5/15, 5/18 & 5/19
etc.
I would somehow have to identify the following, dates:
the 8 day range
the event day
their 2 days off, noting that the days off would be different
for different people ( see scenario's F & G).
The below is what I'm hoping for
I would enter - 5/11, 5/12,5/13,5/14,5/15,5/16,5/17,5/18
I would enter event - 5/14
I would enter days off - 5/16, 5/17
I would get for Scenario A - 5/14, 5/15,5/18,5/19,5/20
I would get for Scenario B - 5/13,5/14,5/15,5/18,5/19
ETC.
Is this possible ?

I sure hope the above chart shows in this post correctly, and I hope I
explained this properly.

Thanks,

Steve