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
When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Similar threads
- Question
