Can you also tell me why you excluded Null values? What is that function doing?
Yes it worked, however I have one more question- in your calculation it shows the max date result but what if you have 2 results for one date as shown below-
I can not exclude Null from the Last Lab, Infection, Last Lab Results because 'Null' in that column means the test is pending. Attaching the workbook-