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.
|