Trying to use a date data validation.

[Stevie-B]

Hi,

I'm trying to add a cell validation so that no one can enter a date of birth for someone aged 18 or over. Instead of putting in the validation box greater than 01/01/90 I want to add the date function so it stays up-dated as the data will be inputed weekly.

Could someone please help......

[Max, Singapore]

I'm trying to add a cell validation so that no one can enter a date of birth for someone aged 18 or over. Instead of putting in the validation box greater than 01/01/90 I want to add the date function so it stays up-dated as the data will be inputed weekly.

This might suffice ..

Assume date inputs will be in A1 down
Select col A (A1 active)
Click Data > Validation
Allow: Custom
Formula: =AND(A1<>"",DATEDIF(A1,TODAY(),"y")<18)
Click OK

[Stevie-B]

Thanks Max.

[Max, Singapore]

welcome, Stevie-B