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

Sorry, have a correction to make. My calendar goes from B3:AG3 (ddd), B4:BG4
(dd), employee names in A5:A10.

Once again, sry about that, and thanks for any help.

SteveD

"SteveD" wrote:

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