If Statement on Expiration Dates
My criteria are the following
- If the Expiration Date Column cell is blank or greater than today+31 days = “Yes”
- If the Expiration Date Column cell is within 30 days = “Hold”
- IF the Expiration Date Column cell = today or greater than the date in the cell = “No”
I tried using ISDate, Index Match, Date Only and it's not working.
Below is the formula
=IF(ISDATE([Expiration Date]11), "Yes", IF([Expiration Date]11 > TODAY(+60), "Hold", IF([Expiration Date]11 <= TODAY(), "No")))
Thank you for the help.
Help Article Resources
Check out the Formula Handbook template!