Heres the short end of what Im trying to do. I am trying to subtract
two dates and return the number of months between the two dates. I can
get this part. The catch here is that I want the number of months to
come back as either whole months or half months. So 1/1/05-2/1/05 = 1
month and 1/1/05-2/15/05 = 1.5 months. My problem is that when I run
the calc I get numbers like 1.64 and using a round will give me 1.6
whereas I would want this number to come back as 1.5.
Any ideas?


--
Rweasel6
------------------------------------------------------------------------
Rweasel6's Profile: http://www.excelforum.com/member.php...o&userid=23251
View this thread: http://www.excelforum.com/showthread...hreadid=379078