How to calculate days past due based on "text" in another column

I need help creating the formula to calculate the number of days an item is past due based on my Status column. The Status column contains the drop-down selection of “Complete”, “Not Started”, and “In Progress”. I want the calculation to return a number whenever “Complete” is NOT selected. I’ve seen variations on this type of question based on using a Complete column and a check box, but I don’t want to have to update two columns when one will suffice to identify if something is complete or not.

Best Answers

Answers