J39L4753 (10/3/2013)
Sorry forgot to add that A8, A9 E8, E9, L8 are cell rows within ExcelColumn A = PersonID
Column E = DateOfAppt
Column L = is the column that I will use to return the answer within the formula.
I realized that, but I was not going to guess column names.
I'm confident you can put the column names yourself in the query.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP