Need help with IF formula using dates

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!
Best Answers
-
Try this:
=IF([Update Date]@row <= [Next Due Date]@row - 30, "due", "not due")
-
Happy to help. 👍️
Answers
-
Try this:
=IF([Update Date]@row <= [Next Due Date]@row - 30, "due", "not due")
-
Thanks SO much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!