Convert number of Days to Year/Month/Day

[rbobcat1]

Which is correct?
4202 Days, have always used the DATEDIF functions and came across another but it doesn't add up.

The DATDIF returns 4202 days to 11 years 6 months 3 days
[=DATEDIF(0,D11,"y")&" years " &DATEDIF(0,D11,"ym")&" months "&DATEDIF(0,D11,"md")&" days"]

But the below returns 4202 to 11 Years, 6 Months, 7 Days
[=INT(D11/365)&" Years, "&INT(MOD(D11,365)/30)&" Months, "&D11-((INT(D11/365)*365)+(INT(MOD(D11,365)/30)*30))&" Days"]

which one is right?

 

[Norie]

I would say the first one as the second doesn't take into account leap years or months which have more/less than 30 days.

 

[rbobcat1]

I would say the first one as the second doesn't take into account leap years or months which have more/less than 30 days.

Good catch I did not see that... Thanks