Hi, I am updating a very large spreadsheet containing diagnostic information about patients. I need to add two columns of information: "Age at first visit" and "Follow-up Day" (the number of days after the first visit). To do this I am using the following formulas: "Age at first visit": =DAYS360(Date of Birth,Earliest Visit Date)/360 "Follow-up Day" =DAYS360(Earliest Visit Date,Visit Date in question).
I work at an eye clinic, so each patient actually usually has 2 visits per visit date (one for each eye), if that makes sense. As I said I have many, many columns of information, but the ones that are of use in this question are as follows:
FirstName / Lastname / Patient ID (unique to each patient) / Eye (Right or Left) / Age at first Visit / Follow-up Day / Visit Date (Chronological) / DOB
As I said, I don't think all of the categories above need to be used, but these are the ones that I thought might be useful.
I'm really having a hard time coming up with any easy way to do this, and I don't know if it is even possible to have a click-and-dragable formula.
Any help would be appreciated!!
I work at an eye clinic, so each patient actually usually has 2 visits per visit date (one for each eye), if that makes sense. As I said I have many, many columns of information, but the ones that are of use in this question are as follows:
FirstName / Lastname / Patient ID (unique to each patient) / Eye (Right or Left) / Age at first Visit / Follow-up Day / Visit Date (Chronological) / DOB
As I said, I don't think all of the categories above need to be used, but these are the ones that I thought might be useful.
I'm really having a hard time coming up with any easy way to do this, and I don't know if it is even possible to have a click-and-dragable formula.
Any help would be appreciated!!