English, asked by naitik2009, 10 months ago

what the formula to convert days into months and year?​

Answers

Answered by Anonymous
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