Mar 30 2021 03:12 PM
Column S is a copy from another tab ( ='other tab'!s3)
As you can see, the result of the if statement is incorrect.... UNLESS I manually enter the date in column S. I suspect some type of formatting issue but am at a loss for what to try.
Mar 30 2021 11:59 PM
The values in column B are right-aligned, suggesting that they are "real" dates.
The values in column S are left-aligned, suggesting that they are text values that look like dates.
Try this:
=IF(B3<>IFERROR(DATEVALUE(S3),0),"OFF","")
Mar 31 2021 04:53 AM
@Hans Vogelaar THANK YOU so much...that resolved the issue.