Hi all,

I have a monthly calendar with the 'Month' in cell A2, the day (ddd) of
month in cell A3:A30, then the day (dd) of the month in B3:B30. Then I have
employee names in C2:C10. What I am trying to come up with, is a table that
shows what day of the week the employee has off, like Thu, Fri. But if his
days off change to Sun, Mon. I can make the change in the table, and it would
make the changes in the calendar. My table is looking like this:

Name    Sun   Mon  Tue  Wed  Thu  Fri  Sat
Jones      W     W     W     W      O    O    W
Smith      O      O     W     W      W   W    W

O = Day Off     W = Day worked

Thanks in advance for any help, advice you might be able to give me.
SteveD