Calculating months with half months.

  • Thread starter Thread starter adelaide
  • Start date Start date
A

adelaide

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!
 
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
 
Back
Top