I have a spreadsheet with multiple columns, a "submitted date" and a "predicted date" (which is 7 days after submitted date) also 3 status columns, "accepted", "accepted as noted" and "not accepted". I am trying to find a formula that will say if one of the 3 columns is not filled in by the predicted date it is ??? days late and then the next column will say yes/no to overdue. Can you please help me? I appreciate it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
"If" formula assistance
Excel Facts
Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Similar threads
- Question
