Need help with IF formula using dates

laura.buchanan

We want to know if someone's annual review is "due"

The Update date is when they upload the annual review and this populates from completion of a form. This is working correctly.

The "next due date" is when it is due and this is working correctly.

The problem is with the "testing IF formula for update" column formula.

The current formula works to say if they upload it prior to the due date it is due and if they upload it after the due date it is not due.

What I prefer to say is if they upload it within 30 days prior to the due date, it is also not due.

=IF([Update Date]@row <= [Next Due Date]@row, "due", "not due")

Can you assist?

Thanks!

Paul Newcome

Try this:

=IF([Update Date]@row <= [Next Due Date]@row - 30, "due", "not due")

Paul Newcome

Happy to help. 👍️

Paul Newcome

Try this:

=IF([Update Date]@row <= [Next Due Date]@row - 30, "due", "not due")

laura.buchanan

Thanks SO much!

Paul Newcome

Happy to help. 👍️