hiya, that works when the cell is repaired cell has a date, but if it has no date, it doesnt work the same. ie. i typed 08/08 in the I2 cell and it makes the formula calculate -2, which is wrong, as the supplier wont received the unit for repair until 09/08, so i need to know how many days they have had it.

This does work ok though, for the formula if it is working out repaired date take away received date (if there is a date in there).

but we are using the formula with some conditional formatting to highlight things that have been gone between 1-5 days, 6-10 days or 15 days or more, so i want the number when at a negative to be accurate.

do u see what i mean?

sorry to be a pain!!