Hi Members,
Hope your near and dear ones are safe
I would seek your help in finding out the previous date to a date if the selected criteria matches
I have two sheets in the attached worksheet, wherein first sheet 'Follow-up Visit' refers to a clinic's bills to patients as free follow-up and the second sheet 'Paid Visit' refers to a paid bill to the patients. The practice followed in the clinic is free follow-up of 7 days from a paid visit date. I have found an array formula to find out the same (I have not used CSD ctrl+shift+enter as I'm using excel 365 with updated dynamic array functions). But here in the formula i also need to check criteria selected in the column K in sheet 'Follow-up Visit'.
For example, if doctor name is selected, the previous paid visit date should be paid visit for the particular doctor and
if Specialty is selected, previous date should be if the specialty matches irrespective of the doctors.
Hope your near and dear ones are safe
I would seek your help in finding out the previous date to a date if the selected criteria matches
I have two sheets in the attached worksheet, wherein first sheet 'Follow-up Visit' refers to a clinic's bills to patients as free follow-up and the second sheet 'Paid Visit' refers to a paid bill to the patients. The practice followed in the clinic is free follow-up of 7 days from a paid visit date. I have found an array formula to find out the same (I have not used CSD ctrl+shift+enter as I'm using excel 365 with updated dynamic array functions). But here in the formula i also need to check criteria selected in the column K in sheet 'Follow-up Visit'.
For example, if doctor name is selected, the previous paid visit date should be paid visit for the particular doctor and
if Specialty is selected, previous date should be if the specialty matches irrespective of the doctors.