nested IF and AND statement
Hello, I need assistance figuring out a formula for a table. its a bit complex. I need cell AE1 to calculate the lowest date between cells AB1 (Symptom onset date) and either cells M1, P1, S1, V1,...
Forum Discussion
=IF(AB1="","",LET(d,DATE(9999,12,31),MIN(AB1,IF(O1="Positive",M1,d),IF(R1="Positive",P1,d),IF(U1="Positive",S1,d),IF(X1="Positive",V1,d))))