View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default how to make this in Excel...

Taking a year 365 days, a month 30 days, assuming number of days being in
cell A3:

years: =INT(A3/365)
months: =INT(MOD(A3,365)/30)
days: =MOD(MOD(A3,365),30)


Regards,
Stefi

€˛Nevermind€¯ ezt Ć*rta:

I have number of days, and i will like thet Excel callculate for me how meny
is that in years, months and days.

1344 working days, how meny is thet in years, month and days?

Please help.

Thanks.