Enter the below in to a cell with A2 as the reference cell as number in days. Assumes 30 days in a month average.
=INT(A2/365)&" Yr(s), "&INT(MOD(A2,365)/30)&" Mo(s) and "&MOD(MOD(A2,365),30)&" D(s)"
Excel Days to Year Months Days Formula
Enter the below in to a cell with A2 as the reference cell as number in days. Assumes 30 days in a month average.
=INT(A2/365)&" Yr(s), "&INT(MOD(A2,365)/30)&" Mo(s) and "&MOD(MOD(A2,365),30)&" D(s)"