Calculating days between clinic visits

Closed
eyedoc2020 Posts 1 Registration date Friday 31 May 2013 Status Member Last seen 31 May 2013 - 31 May 2013 à 11:43
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Jun 2013 à 18:12
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 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
1 Jun 2013 à 18:12
you can leverage MATCH function. If a match is found then you can subtract dates