assume cell A1 contains 4 years 8 months

in B1 put this formula

=(value(left(A1,1))*365)+(value(mid(A1,9,2))*30.4)

this does not allow for leap years or the fact that months have either
28, 30 or 31 days.

If you know that 4 years 8 months zero days is correct on todays date,
you can calculate date of birth and then subtract that from todays date
which gives the exact number of days.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=529916