How to Convert Numbers (Days) To Year/Month/Day

 

Convert Numbers (Days) To Year/Month/Day

This method will introduce a formula to convert the number of days to year/month/day such as "1 year 4 months 25days" in Excel. Please do as follows:

Select a blank cell you will output the conversion result, and enter the formula =DATEDIF(0,A2,"y")&" years " &DATEDIF(0,A2,"ym")&" months "&DATEDIF(0,A2,"md")&" days"  (A2 is the cell with number of days that you will convert to year/month/day) into it, and press the Enter key.

Keep selecting the cell of conversion result, and drag its Fill Handle to the range as you need. And then you will see all numbers are converted to year/month/day. See screenshot: