Check a Date Range
I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days.
“Date” = 07/10/22
Today’s Date = 07/22/22
Is the “Date” within the range: 07/01/22 – 09/20/22*? In this example, it would be true and return “Yes”.
*09/20/22 derived from Today+60 days
What is the easiest way to do this? Asking before I end up in a formula quagmire.
Help Article Resources
Check out the Formula Handbook template!