Forum Discussion
Solved
calculate number of days if cell is empty.
Hello greetings ! I have an excel with 4 columns, in the first column the identification of the quote is recorded, the second column identifies the date the person received the quote by mail...
Jhonny97or Suppose we are looking at row 1, then the formula in D1 could be
=IF(ISBLANK(C1),TODAY()-B1,"")
Jhonny97or Suppose we are looking at row 1, then the formula in D1 could be
=IF(ISBLANK(C1),TODAY()-B1,"")
Thank you very much, it was what I needed