how to use excel to creat an oncall schedule

[Guest]

i wantb to creat oncall schedule for doctors in a hospital. each 2 doctors
would be on call for 12 hours a day. it can look like calendar and it should
calculae how many days each one was oncall up to date.

 

[Guest]

Let's say we have twelve worksheets in a workbook, one for each month.

In each worksheet there would be one column for each doctor, doctor's name
in the top row. Rows 2 thru 32 could correspond to the days of the month.
Enter a 1 if the doctor was on-call that day.

At the bottom of each worksheet in row 35 enter formula like:

=SUM(A2:A32) and copy across.