help with a formula?

[e***@gmail.com]

Need assistance with a formula to track the number of days an issue
has been open. We have a start date and a resolved date column but if
the issue hasn't been resolved we need to have a value based on todays
date. We have been struggling with this and any help you can offer
would really be appreciated!

[e***@gmail.com]

Thanks so much for all your help!

:(

Post by e***@gmail.com
Need assistance with a formula to track the number of days an issue
has been open. We have a start date and a resolved date column but if
the issue hasn't been resolved we need to have a value based on todays
date. We have been struggling with this and any help you can offer
would really be appreciated!

[RUSS BARTOLI]

Using Lotus 1-2-3:

@IF(resolvedDate,resolvedDate,@today)-startDate

Post by e***@gmail.com
Thanks so much for all your help!
:(

Post by e***@gmail.com
Need assistance with a formula to track the number of days an issue
has been open. We have a start date and a resolved date column but if
the issue hasn't been resolved we need to have a value based on todays
date. We have been struggling with this and any help you can offer
would really be appreciated!