difficult to be precise, as it depends upon the start point, but this might
get you started

=DATEDIF(TODAY(),TODAY()+A1,"y")&" years, " &
DATEDIF(TODAY(),TODAY()+A1,"ym")&" months,
"&DATEDIF(TODAY(),TODAY()+A1,"md")&" days"

--
HTH

Bob Phillips

"Dave Cobb" wrote in message
news:rfLke.1280$5T2.1163@trnddc01...
I want to convert the number of days in a cell (ie: 2350) to Xyears and
Ymonths. What formula to use?

Thanks,
Dave