# Formula to count number of Days and not counting Status

✭✭
edited 11/22/23

Hi everyone. I hope everyone is doing well. I was wondering if I could please get some help. I have a tracker named eAPP, I am trying to count the number of Days since Assigned for 0 to -12 days but exclude in the count if the Current Status is "Completed". I have tried so many formulas, but nothing is working. Thanks. Brian

• Overachievers

Hi @Peppey

Apologies updated formula

If(Contains("Action Complete",[Current Status]@row),"",Today()-[Days since assigned]@row)

Thanks

Paul

• ✭✭

Perfect thank you so much

• Overachievers

Hi @Peppey

Without seeing sheet specifics I would use something like this:

If(Status@row = "Completed","",Today()-Assigned@row)

Assumption that status column contains where the completed is updated and the assigned column is where the date would be and that column is formatted as a date.

Hope that helps

Thanks

Paul

• ✭✭✭✭✭✭

Hello @Peppey - I guessed at your exact column names:

=IF([Current Status]@row = "Complete", "", TODAY() - [Assigned Date]@row)

• ✭✭

Thank you both sir! I apologize I should have been more specific. There is an autocalculate column int he tracker and need the count the autocalculate days showing the numbers. For example, in the autocalculate column in the tracker there are number such as 0, -12, -28, etc. I need to count the number of 0 to -12 from this column (named Days since assigned).

• ✭✭✭✭✭✭

Could you please post a snip of that column? It would help to understand the data a little better

• ✭✭

Yes of course. See below

• Overachievers

Hi @Peppey

Apologies updated formula

If(Contains("Action Complete",[Current Status]@row),"",Today()-[Days since assigned]@row)

Thanks

Paul

• ✭✭