View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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")&" "