Time Frame

[Richard]

I have a data set where I would like to identify patients that have been seen
for at least 6 months. Each row of data contains info about a particular
visit and includes the date of service. I can use a pivot table to organize
all the service dates for one patient however I can't think of a way to add a
formula for Excel to calculate the difference between the earliest and latest
date. Each patient has a different number of visits so its tough to just
copy down. Is there a way to accomplish this without manually going one at a
time?

 

[Bob Phillips]

Layout some sample data to work with.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)