Pressing Problem!

I've tried for the pass four days to figure out a way to obtain
information from two ranges and present the results either in a
separate userform or on the worksheet.

Can anyone help?

Problem: How do I determine what shift a particular worker is working
based on either the current date and/or a selected date?

Range one contains the compressed work week schedule, listing each
day..
i.e.,
CWW Schedule
M T W T F S S M T W T F S S
26 27 28 29 30 1 2 3 4 5 6 7 8 9
10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 31 1 2 3 4 5 6
7 8 9 10 11 12 13 14 15 16 17 18 19 20

Shift Rotation
M T W T F S S M T W T F S S
A E E E X X X X X N N N N N N
B X N N N N N N N X X X D D D
C N X X X D D D D D D D X X X
D D D D D X X X X X X E E E E
E X X X E E E E E E E X X X X


If Robert is working "A" and scheduled to work the 29th. What
would he be working based on the current date or selecting a date. He
should be working "X" shift.

I can't figure out how to lookup two ranges and present the results.

Thanks for your help!
Titus