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.