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!

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!