I believe this will work for age 18, replace 'x' with your cell reference to
the age.
=IF(DATE(YEAR(x)+18, MONTH(x), DAY(x)) < TODAY(), "Old Enough", "Too Young")
You avoid worrying about leap years by piecing the date together from
components.
"Cobbcouk" wrote:
Hi,
I am trying to write a formula that will return a value of "Yes"; if
the date in cell E1 for arguments sake, is less than 18 years ago.
Conversely, if the date is more than 18 years ago it needs to return
"no".
Hope y'all can help?
Regards
G
--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=564779