Date Difference

[Art Wrok]

I would like a formula to determine if someone is 70 1/2 at the end of
a year. I used
=DATEDIF(DateofBirth,EndofYear,"y")
but the result is only accurate to a whole year, for example
DateofBirth = 6/30/1937 and EndofYear = 12/31/2007 gives 70.0
rather than 70.5. How can I do this?

 

[Mangesh]

you could try:
=DATEDIF(DateofBirth,EndofYear,"m")/12