Hello All!
I'm trying to figure out how to count multiple appointment dates.
For example, a client had the following appointments for 2016:
2/5/2016 5/1/2016 7/22/2016 9/10/2016 12/7/2016
[TABLE="width: 288"]
<colgroup><col width="64" style="width: 48pt;" span="6"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]E[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ROW 1[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2/5/2016[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5/1/2016[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7/22/2016[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9/10/2016[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]12/7/2016[/TD]
[/TR]
</tbody>[/TABLE]
At a glance, I see the client has been to our practice 5 times since he had 5 appointments.
What simple formula can I use to count all appointment dates?
I'm trying to figure out how to count multiple appointment dates.
For example, a client had the following appointments for 2016:
2/5/2016 5/1/2016 7/22/2016 9/10/2016 12/7/2016
[TABLE="width: 288"]
<colgroup><col width="64" style="width: 48pt;" span="6"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]E[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]ROW 1[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2/5/2016[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5/1/2016[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7/22/2016[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9/10/2016[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]12/7/2016[/TD]
[/TR]
</tbody>[/TABLE]
At a glance, I see the client has been to our practice 5 times since he had 5 appointments.
What simple formula can I use to count all appointment dates?