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...
Select cell A1 and set validation for that cell. Make sure you choose Date in the Allow box. After that, set the other options appropriately.