Hi everyone,

I’m trying to improve my current formula for calculating task in flight.

`NetWorkingDays(thisRow.[Created on],Today() )`

The issue i now have is when the task is changing Status to “Done” this formula is still applying therefore I can’t look at how long the task was in flight as it still applies the today() function

**So I would like something like:**

`NetWorkingDays(ThiRow/[Created on], if thisRow.State is "done" then Date it was modified to "done" or Today()`

But I’m struggling to have a valid formula. If anyone could help that would be much appreciated.

All the best