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. J

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.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try this...

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

Jerome Belen

Hi Paul,

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

Paul Newcome

Even if you enter a date in the future?

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.