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

kalyan Source

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.





answered 1 month ago pnuts #1

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


comments powered by Disqus