Previous Topic Next Topic

Calculating days between clinic visits

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

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

Similar discussions

Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

Hello, I hope whoever reads this message is well!  I’ve been experiencing an issue since before Christmas and I have no idea what to do. When opening Instagram the app, it always tries to get me to update my email address. After doing the app states I won’t have access to some settings for a few days. This has been going on since December, I’ve tried updating my email address on multiple devices to no avail. (See photos) Any guidance/help would be much appreciated. Thank you! 

1 response
this account will be disabled in 28 day you only have 28 days left to request a
Chandrakantmahire -
Treasurelove -

this account will be disabled in 28 day you only have 28 days left to request a review. after that you account will be permanently disabled

2 responses
This account will be disabled in 1 day Are you sure that you want to log out? Y
Usman -
dwebb -

This account will be disabled in 1 day
Are you sure that you want to log out?

You only have 1 day left to request a review. After that, your account will be permanently disabled.

1 response
You have 30 days to request a review
Dibakar -
HelpiOS -

Hello,

Your Facebook account has been disabled. This is because your account, or activity on it, doesn't follow our Community Standards.

If you think that we've disabled your account by mistake, we can take you through a few steps to request a review. You'll need to complete these steps within 30 days to avoid your account being permanently disabled.

Please help!

1 response
This Account Will Be Disabled in 18 Days Are you sure you want to log out?
Vishwaswamy -
Vikash -

Hello,

This Account Will Be Disabled in 18 Days
Are you sure you want to log out?

You only have 18 days left to request a review. After that your account will be permanently disabled.

9 responses