If Statement on Expiration Dates

06/30/20
Answered - Pending Review

My criteria are the following

  1. If the Expiration Date Column cell is blank or greater than today+31 days = “Yes”
  2. If the Expiration Date Column cell is within 30 days = “Hold”
  3. 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.

J

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try this...

    =IF(TODAY() >= [Expiration Date]@row, "No", IF([Expiration Date]@row <= TODAY(30), "Hold", "Yes"))

    thinkspi.com

  • Hi Paul,

    Thank you for your response. I tried it but now any date entered it equals to No.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Even if you enter a date in the future?


    Double check that your column as formatted as a date type column.

    thinkspi.com

Sign In or Register to comment.