ExcelBanter - Calls per Day

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calls per Day (https://www.excelbanter.com/excel-discussion-misc-queries/202916-calls-per-day.html)

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.

"Nate" wrote:

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.