Extension of formula for days overdue

Hi All,

Hoping one of you is able to assist me :pray:

I am trying to track days over due for contracts so that all stakeholders in projects can stop passing the blame.

Essentially, I have been able to calculate days over due but I would like to know if there is a way I can stop this number rising once the status changes to ‘complete’ or at a minimum revert to 0 (ie. No days overdue).

Is this possible?! Can you PLEASE help me

Days overdue formula is currently: (ROUND(DAYS({Due Date},TODAY()),0))


Hello @SammieWilliams ,

Welcome to the community!

Try this :slight_smile:

IF({Status - Current Week}="Completed","Completed",(ROUND(DAYS({Due Date},TODAY()),0)))


Giannis, Implementation Consultant at thespelas.com

Thank you very much Giannis!

We will not days overdue before changing status! You’re assistance is much appreciated.

1 Like