| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| How do I make make comment format default? | Excel Discussion (Misc queries) | |||
| make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
| Excel templates. Wanna make excel look like regular blue lined pap | Excel Discussion (Misc queries) | |||
| how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
Linear Mode
