I have two date columns I am comparing.
If Date 1 = Date 2 then "On Time"
If Date 1 > Date 2 then "Early"
if Date 1 < Date 2 then "Late"
The problem I am encountering is that there are blanks in some Date 2 rows and it is calculating that Date 1 = Date 2. I don't see how it thinks a blank cell equals a date value in another cell? Or it is also calculating that Date 1 is greater than Date 2 when Date 2 is blank.
Any ideas?
If Date 1 = Date 2 then "On Time"
If Date 1 > Date 2 then "Early"
if Date 1 < Date 2 then "Late"
The problem I am encountering is that there are blanks in some Date 2 rows and it is calculating that Date 1 = Date 2. I don't see how it thinks a blank cell equals a date value in another cell? Or it is also calculating that Date 1 is greater than Date 2 when Date 2 is blank.
Any ideas?