Forum Discussion
Data Validation Criteria
I have the following formula in Cell B1: =YEAR(NOW())-YEAR(A1) The date in Cell A1 is: 05/05/2005 The results of my Cell B1 come up with the error: I am trying to use the Data Validation to...
I found a solution. I used the validation criteria of Date is Less than today's date. This allows me to pick off the incorrect date entry in the cell.