Formula to test for Date + If Date Is Within One Year

I know that =IF(DATE@row <> "", "Green", "Red") will tell be if there is a Date.

I need to add one more condition. That the date is also within the last year.

Can someone please help me?

I want the column to be Red if either condition fails and Green if both conditions are met.

Find more posts tagged with

Accepted answers

All comments

See if this is what you need:

=IF(AND(Date@row <> "", Date@row >= TODAY() - 365), "Green", "Red")

Hope this helps!

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.