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 2004 - 2007,
andrewsexceltips.com
. All Rights Reserved.