Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i need to do a calculation. Example:
I have a Figure i.e. 3 Years 10 Months and 28 Days If I add 1one, 4 months and 4 days to it, normally the result will appear as 4 years, 14 months and 32 days. What I want is to have the result is 5 years, 2 months and 2 days. Year Month Days 3 10 28 1 4 4 4 14 32 It should appear as 5 2 2 Anybody can help?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculation | Excel Worksheet Functions | |||
Age calculation | Excel Discussion (Misc queries) | |||
calculation | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |