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
How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Similar threads
- Question
