I want to stop counting dates based on other cells.
cell B25 = date we received a document from customer
Cell B27 = First reminder sent customer to send us the document
Cell B28 = second reminder sent
I want the formula to count how many days from the date in cell B27 and stop counting when a date is put in cell B28. However if Cell 28 is empty I want the cell that the formula is in to stay clear. Likewise if we don’t have to send the second reminder then the formula to count the days from B27 to B25
i have tried using multiple IF statements but because I have it saying if Cell B25 is empty count B27-28 days but if B28 is empty to 27-25 it gets confused and I get an error message.
is this possible or is it too elaborate?
cell B25 = date we received a document from customer
Cell B27 = First reminder sent customer to send us the document
Cell B28 = second reminder sent
I want the formula to count how many days from the date in cell B27 and stop counting when a date is put in cell B28. However if Cell 28 is empty I want the cell that the formula is in to stay clear. Likewise if we don’t have to send the second reminder then the formula to count the days from B27 to B25
i have tried using multiple IF statements but because I have it saying if Cell B25 is empty count B27-28 days but if B28 is empty to 27-25 it gets confused and I get an error message.
is this possible or is it too elaborate?