There is not an exact way since there are leap years, if you don't care about
100% precision you can use =A1/365.25 or if you just want years without any
decimals

=YEAR(A1)-1900


Regards,

Peo Sjoblom

"Dave Cobb" wrote:

I want to convert the number of days in a cell (ie: 2350) to Xyears and
Ymonths. What formula to use?

Thanks,
Dave