I'm organizing a library checkout system for my job. I made a formula to determine how much of an overdue fee should be owed if it's $1 per day up to 14 days, after which a $20 re-stocking fee is assessed. The formula I created is as follows:

=IF(OR(F3=DATE(1904,1,15),F3-$E$1>0),"None",IF(AND(F3-$E$1<0,F3-$E$1>=-14),F3-$E$1,-20))

Where E1 is Today() and F3 is the due date. This function works perfectly on one sheet, but when I copy/paste and adjust the reference cells, the other sheet returns only date values. The date values are still technically correct (for example if the value is supposed to be -5, it shows up as -1/6/1904), but I want them to show up in a more user-friendly way.

Any suggestions are appreciated! Thanks!