problem of converting days months and years
 

Hi i have a problem in excel ..i m new of excel so dont have enough
knowledge so do help me ..suppose i have the following data
A2 = Years = 9
B2 = Months = 175
C2 = Days = 392

i want to calculate these months and dates as supoose i have 0 years 24
months and 32 days so answer should be as 2 years 1 month and 2 days
because (24 months = 2 years and 32 days = 1 month and 2 days are left
as in the column of days).......

so plz help me thanks in advance......bye take care friendssss


--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile: http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=568832