Which means, my little calculation in Cell C615 ( =D615-D614) could
actually
return a negative number if the items were not data entered in
Chronological
order.

Given the above, I think you could have a bigger problem then you realize.
You are concerned with a negative value being generated from the calculation
=D615-D614, but if the entries are not being made in chronological order, it
would seem the the values that need to be subtracted could be separated by
several rows rather than be simply in reverse order. If that is the case, I
would think it would make any calculations based on this formula incorrect,
right?

Rick


"Gina" wrote in message
...
I have possibly screwed up in a big way.

In my spreadsheet I have assumed that records would be added
chronologically
(as they should), and did not allow for the fact that people don't always
do
as they should.

Which means, my little calculation in Cell C615 ( =D615-D614) could
actually
return a negative number if the items were not data entered in
Chronological
order.

I'm not sure whether the formula in Cell C615 should be altered to say-
look
at the date in Cells D002:D2500 and find the one with a date nearest, but
less than cell D615- and subtract that date from cell D615 and return the
value to Cell C615--- or if I should somehow prevent records from being
entered out of order.

Any ideas or help would be very greatly appreciated.

Gina