format a cell to accept a date or a whole number
 

I need the cell to accept a whole number as an age or date of birth

format a cell to accept a date or a whole number
 

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