Jul 25 2019 08:22 PM
I have a spreadsheet where one cell has a calculation for the number days since an invoice was sent and there is a second cell for the number of days since a revised invoice was sent. At issue is that there isn't always a revised invoice, so on those cells where there is no date for the calculation excel is attempting to calculate and just putting a number that has nothing to do with anything. Right now I was just using =TODAY()-G3, if G3 is empty the number appears, I want to get rid of the number. Thanks!!