Try this
=ROUND(DATEDIF(H22,(L22),"y")+(DATEDIF(H22,(L22)," ym")/12),2)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"UPRAYUP" wrote in message
...
Please can someone help me.
I need formula to get age and month
I use the following, but get (example 53 0 instead of 53.0)
=DATEDIF(H22,(L22),"y")&" "&DATEDIF(H22,(L22),"ym")&" "
|