Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating months with half months.
I figured out how to have excel calculate the number of months, but I want to
be able to round off to half months. So if its 7/15/08 to 10/31/08 I want it to auto calculate 3.5 months. Or 7/15/08 to 10/15/08 to cound 3 months. If the value is from July 2-14, to count as .5 if July 15-31 to round down to 0. Was hoping this was possible if anyone knows the formula. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating months with half months.
Hi,
Modify whatever formula you used to calculate the number of months by adding: =MROUND(myformula,.5) The MROUND function is part of the Analysis ToolPak - to attach that choose Tools, Add-ins and check the box beside Analysis ToolPak -- Cheers, Shane Devenshire "adelaide" wrote: I figured out how to have excel calculate the number of months, but I want to be able to round off to half months. So if its 7/15/08 to 10/31/08 I want it to auto calculate 3.5 months. Or 7/15/08 to 10/15/08 to cound 3 months. If the value is from July 2-14, to count as .5 if July 15-31 to round down to 0. Was hoping this was possible if anyone knows the formula. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating months | Excel Worksheet Functions | |||
calculating months | New Users to Excel | |||
Need help calculating months | Excel Discussion (Misc queries) | |||
Calculating months | Excel Discussion (Misc queries) | |||
Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions |