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!