DataValidationCustom. Formula: =AND(A10,A1<TODAY())

--
Kind regards,

Niek Otten

"trick95" wrote in message
...
I need the cell to accept a whole number as an age or date of birth