I have a worksheet that calculates the number of days between when we received a customer return in versus the date we sent back to the customer. The first part of my question is why I am getting a large negative number as a result. (I think I need to filter out using an IF statement) My second question is I need to be able to include in my average the items not yet sent back otherwise I am misstating my average. Any help would be appreciated.
Bookmarks