Forum Discussion
DrewVoge
8 years agoQrew Cadet
this is the formula from one of my apps for the exact same purpose.
If([Status]="Closed",[Date - Closed]-[Date - Opened],Today()-[Date - Opened])
If([Status]="Closed",[Date - Closed]-[Date - Opened],Today()-[Date - Opened])