# Formula for over due tasks using checkbox.

• 0
• Question
• Updated 4 years ago

Using check box to complete a task. Field is called completed. Need help to make formula for days overdue. Thanks all!

• 0 Points

Posted 4 years ago

• 0
• 72,226 Points
Can you explain in English what the calculation needs to be?  So far i only know that you have a table with a checkbox field in it.
• 0 Points
how many days a project is overdue from the due date of the task. I am using a checkbox for when a task is complete. So once the task is past the due date and is not checked as complete, i need to know how many days it is past due. Happy to provide any more info and thank you.

Jack, Champion

• 50 Points
Hi Ken,

Create a formula duration field and set the units to days and use a formula like:

If(
[completed]=true,days(0),
Today()-[Date due field]<Days(1),Days(0),Today()-[Date due field])

Depending on whether you count the day due you may need to subtract one day from the answer.

If(
[completed]=true,days(0),
Today()-[Date due field]<Days(1),Days(0),(Today()-[Date due field])- days(1))

If this isn't what you wanted please can you elaborate a little on your requirements.
• 0 Points
Success! You did create the formula. Thank you very kindly.

Jack, Champion

• 50 Points