Hello Claus, thank you for coming to my aid.

Basically, I am working on a library-based Excel file.

What happens is, the Excel has a check out date (Cell A), and a check in date (Cell B). If books are returned exceeding 30 days (Cell B - Cell A), this would be reflected in Cell C on showing the number of days it's been overdue. A fine would also be calculated in Cell D, $1 is charged for every day overdue, with a maximum of $60 that we are allowed to collect by policy.

The problem is here, at times when books are still not returned over 60 days, (say 61 days), I want the cell to show a maximum of 60 only coz that's the maximum we can collect), at the same time, I don't want cells to show "-42076" when books are not returned yet.

Is there a solution to this?