Date comparison/specific order

Question

Objective: Compare sequence of dates that date 1 has to be the furthest out and date 6 the earliest and return any errors.

example:

Record 1 no issues

Record 2 no issues but missing data

Record 3 Date 4 is an issue

Record 4 No issues except no data in Dates 4, 5, and 6

Record 5 No issue except dates 5 & 6 are the same

Dates.xlsx

JamesCopeland67 · Answer

in other words adding a column that says "is it good" yes or no and if no where the error is

JamesCopeland67 · Answer

just need to return as in record 3 that date 4 is an error and record 5 the dates in 5 & 6 match which is also an error

atcodedog05 · Answer

Hi @JamesCopeland67

Can you provide the expected output?