Quote:
Originally Posted by gebobs
Days Past = TODAY()-[Date Create cell]-VLOOKUP(A2,Level,2,FALSE)
Or if you don't want to create a table and do a lookup:
Days Past = TODAY()-[Date Create cell]-IF([Risk cell]="High",45,IF([Risk cell]="Severe",30,15))
|
Thanks gebobs the last one works great.
Only other question is there a way to make any of the ones that are within the 45, 30, and 15 days show as a -# and the rest as positive.
I really appreciate you help with this.