rbobcat1
New Member
- Joined
- Dec 19, 2011
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
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?
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?