conversion question
Maybe
=INT(A1)&" Years "&ROUND(MOD(A1,1)*12,2)&" Months"
where A1 = 5.08
which is 0.96. If you have specific start/end dates, you may want to look
at DateDif. Whether or not 0.08 of a year is one month depends on which
month you're talking about.
"Tammi P" wrote:
is there a formula to convert 5.08 into years/months? I know 5 = 5 years,
but can't figure out how to determine what .08 is. Thanks
|