You're welcome.

"Tammi P" wrote:

> 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