Try:
Years:
=A2+ INT((B2*30+C2)/360)
Months:
=INT(MOD((B2*30+C2),360)/30)
Days:
=MOD(B2*30+C2,30)
HTH
"naughtyboy" wrote:
Hi friends..i have a problem in ecel. supose i have the following excel
sheet
A2 = Years = 0
B2 = Months = 47
C2 = Days = 95
i ma ssuming 365 days in a year and 30 days in a month..
now i want to convert these days and months into years months and days
as answer should be 4 years 2 months and 5 days i want a formula to
calculate the answer.....
i am using the following formulas for this problem.
Years: =A2+INT(B2/12)
Just in case the days =360 change to:
=A2+INT(B2/12)+INT(C2/360)
Months: =MOD(B2+INT(C2/30),12)
Days: =MOD(C2,30)
but these formulas give me answer as 3 years 2 months and 5 days.as it
is wrong it should be 4 years 2months and 5 days..
i will be evry thank ful to u.plz do help meeeeeeeeee
--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile: http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=573395