Hi
Is there a formula that would search one cell for a month and then search a
range of other cells for a date and then look below and report into the
formula cell what is reported possibly in a different colour depending on
what is reported.
e.g.

               A              B              C               D            
E              F                G
1                         Date 31…Month December…Year 2007                2               
3               MON    TUE    WED    THU    FRI    SAT    SUN
4               31    1    2    3    4    5    6
5   smith    E    E    DO    S    E    DO    DO
6   jones    DO    N    DO    DO    DO    DO    N
7
8
9
The cell in A9 would search cell B3 to find the month required, then would
search cells A4 to G4 for the correct date e.g. recognise that the required
date is the 3rd of january in cell D4.  It would then look below in jones's
line and report back S in red.
Thanks in advance
Jason