Calls per Day

  • Thread starter Thread starter Nate
  • Start date Start date
N

Nate

I am trying to track the number of calls per day entered onto our tracking
form.
Office Patient Name Phone Number Call Date Call Outcome
Springfield Nate R. (610) 555-3535 7/30/08 NWA
Springfield Kate E. (610) 555-3232 8/31/08 NI
Springfield Dawn C. (610) 555-3434 8/31/08 CB

I was using a formula =IF(D3 = D2, 0, 1). But that was dependent on all the
calls being entered in chronological order, and I wanted to see if there was
a better way of doing it? Thanks in advance.
 
=COUNTIF(F3:F5,F5)
F3:F5 is the range including the dates. F5 is the cell that contains
8/31/08. The result of this function is 2.
 
Back
Top