=IF(DATEDIF(E1,TODAY(),"Y")<18,"Yes","No")

"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