One column is actual date, next column is day of week, next column is a two
letter code unique to each doc .( ie TR )

"T. Valko" wrote:

Ok, how about describing your layout.

I assume you have Doc names as one axis and the dates as another axis. Are
the dates real dates like 4/1/2007 or are they the days of the week as TEXT
entries like MONDAY? How do you denote if Doc X has taken a call?

Biff

"grebnet" wrote in message
...
For each day of the month I will put one of 10 different docs on call. It
is
important that the number of total calls and number of calls taken for
each
day ( ie Mondays,tuesdays.....) are equal . Especially dont want one Doc
doing more weekends than another. So I would like to have a function that
will count How many Mondays Doc X does, how many Tuesdays...... Then
total
each up for each month and keep a running total for the year. ( in this
case the year will start April 1st )

Thanks

"T. Valko" wrote:

Need more detail

Biff

"grebnet" wrote in message
...
I am setting up a physician call schedule.10 people 7days/week. Can I
have
excel count how many times each doc has taken call on each day .