=FLOOR(A1-A2,500)

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"John" wrote in message
...
I was wondering if anyone can tell me if this is possible. I need to
create
a formula based on the results of date in two separate fileds. Suppose I
have a field with 31064.47 and another with 28738. I wand to subtract the
2nd number from the first, then round the result to the nearest increment
of
500. For example, 31064.47 subtract 28738 equals 2326.47. I would like
to
round that result down to the nearest increment of 500 or 2000.

Can this be done, and how?