CODEWITHSUNDEEP
google-sheets
kalyan
kalyan

Reputation: 375

How To Calculate Age From Birth Of Date and have a validation check for this In Google Sheet

I have a spreadsheet with a column for DOB. However, the age should be over 18 years from today.

How can I have a validation with a custom validation formula where en error should be pop up if the age is below 18 years.

Thanks

Kalyan

Upvotes: 0

Views: 243

Answers (1)

pnuts
pnuts

Reputation: 59450

In Data > Data validation... please try a Custom formula is of the kind:

=DATEDIF(A1,today(),"Y")>17

Upvotes: 1

Related Questions