Years as decimal number

Posted by Jim on January 11, 2002 8:14 AM

If I subtract one date from another, how do I format the result as a decimal number to express the number of years with 2 digits to the right of the decimal?

Posted by Mark W. on January 11, 2002 8:21 AM

And... what do you want to the left of the decimal? (nt)

Posted by Mark W. on January 11, 2002 8:24 AM

Hmmm... maybe you mean... =ROUND(YEARFRAC(A1,B1),2) (nt)

Posted by Mark W. on January 11, 2002 8:28 AM

If you do use YEARFRAC consult Help file for info on optional, 3rd argument (nt)

Posted by Jim on January 11, 2002 8:50 AM

This is it, thanks

Works the same as ROUND((A1-A2)/365),2). I just thought there should be a better way to do it using some date function and you provided it. Thanks!