how to make this in Excel...
 

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.

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.

how to make this in Excel...
 

Nevermind - what does it mean "working days" in your example? Do you want
to include weekends to your calculation (then calculation depends on
starting data and is not such simply)?

Regards
Mario

U¿ytkownik "Stefi" napisa³ w wiadomo¶ci
...
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.

how to make this in Excel...
 

No, Stefi answer was good!

But, thanks to everybody!



"MaC" wrote in message
...
Nevermind - what does it mean "working days" in your example? Do you want
to include weekends to your calculation (then calculation depends on
starting data and is not such simply)?

Regards
Mario

U¿ytkownik "Stefi" napisa³ w wiadomo¶ci
...
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.