Age Check
To see if someone is 20 years old or over use this formula (TRUE means that they are)
=AND(ISNUMBER(A1),(A1-1)<DATE(YEAR(TODAY())-20,MONTH(TODAY()),DAY(TODAY())))
© Copyright
andrewsexceltips.net
All Rights Reserved.