Calculating days between clinic visits [Closed]

Report
Posts
1
Registration date
Friday May 31, 2013
Status
Member
Last seen
May 31, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have a database with two columns, column A is date of clinic visit, and column B is patient name. I would like to be able to calculate the average days between clinic visits per patient. Im having lots of trouble figuring this out, I would greatly appreciate if anybody could help.

Sample database:

A B
16-Mar-10 Smith, John
10-Oct-12 Smith, John
22-Dec-12 Smith, John
5-Feb-09 Smithers, Jane
24-Nov-12 Smithers, Jane
5-June-11 Springer, Mary
12-May-13 Stein, Jason

It would like to figure out a way for column C to display days between exams for each patient (ie Smith, John would be 939 days between visit 1 and 2, and 73 days between visit 2 and 3).

Thanks to all,

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
you can leverage MATCH function. If a match is found then you can subtract dates

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!