If you have a text entry in A1 like
10 years 4 months
then this formula will give the date of birth
=EDATE(NOW(),-LEFT(A1,FIND(" ",A1)-1)*12-MID(A1,FIND("m",A1)-3,2))
note: EDATE requires analysis toolpak addin
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=529916