format a cell to accept a date or a whole number

trick95 · Mar 4, 2006

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

Niek Otten · Mar 4, 2006

Data>Validation>Custom. Formula: =AND(A1>0,A1<TODAY())