Thumper007
New Member
- Joined
- Jan 22, 2020
- Messages
- 5
- Platform
- Windows
Hello, I have a formula that I am using to calculate number of days a task has been open. I have added a col (col B) to include a status. Now I am looking to add to my formula either only calculate if the status “open”. Thoughts??
current formula:
=IF(CI59=0’””’NETWORKDAYS(CI59,IF(CL59=“”,Today(),CL59)))
current formula:
=IF(CI59=0’””’NETWORKDAYS(CI59,IF(CL59=“”,Today(),CL59)))