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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!