Thank you! I will see if there are specific start/end dates - although I'm
not sure how to use the DateDif - so I may post again.
"JMB" wrote:
> 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
Bookmarks