Rounding Question

[Rweasel6]

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

 

[N Harkawat]

=floor(1.64,0.5)
will reduce 1.64 to 1.5
so you could enclose your formula as

=floor(your formula,0.5)

also take a look at function CEILING to round up your values to nearest 0.5

 

[Rweasel6]

works great thanks!!!