what the formula to convert days into months and year?
Answers
Answered by
2
Explanation:
Convert numbers (days) to year/month/day
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.
plz mark as branliste
Similar questions