I need help with a formula. I want to mark overdue projects.

Cristina W

This is a sample of the projects I have, and this is the formula I am using, but it does not seem to be working: =IF([End Date]@row > TODAY() +30), "Overdue"

Eric Law

@Cristina W Try =IF([End Date]@row < TODAY(30), "Overdue")

With the formula, you are capturing anything over 30 days past due or within 30 days??

If it is within the next 30 days, the formula works as above. If past 30 days, change the number to -30

Eric Law

@Cristina W Try =IF([End Date]@row < TODAY(30), "Overdue")

With the formula, you are capturing anything over 30 days past due or within 30 days??

If it is within the next 30 days, the formula works as above. If past 30 days, change the number to -30

Cristina W

Thank you @Eric Law