Days open unless Status = Closed, then stop.
I need a days open field to count up, UNLESS another field (Status) is equal to closed. If Status is is equal to closed, the days open should stop at the number of days between creation and the date t...
Forum Discussion
Suggestions for how to tailor this to also factor in only the amount of week days open?
This formula worked perfectly for my days open indicative of an item not being closed, but I foresee the team wanting it to reflect only the number of business days open.
Thank you,
Allison
------------------------------
Allison Lewey
------------------------------
WeekdaySub(Today()-[Date - Opened]) I think changing the end of the formula to this would do it. You may have to reverse it and have date - opened first.