Forum Discussion
Solved
Understanding a Data Validation formula
One of our employees has imported a Google Sheet into Excel and one of the cells contains this formula; =OR(NOT(ISERROR(DATEVALUE(I8))), AND(ISNUMBER(I8), LEFT(CELL("format", I8))="D")) If you ente...
Another workaround might be to simplify the data validation and use date validation as such:
This avoids the use of CELL.
Another workaround might be to simplify the data validation and use date validation as such:
This avoids the use of CELL.