Calculate days past due based on end date
I want to populate a column labeled "Days Overdue". I want to look at my column "% Complete" if "% Complete" is not equal to 100%, then get TODAY() date - "End DATE" and populate the value into "Days Overdue" column, else 0.
In excel I can accomplish this with the following IF statement. =IF(% Complete<>100%,TODAY()-END DATE,0)
Help Article Resources
Check out the Formula Handbook template!