Future date function

Hello,

I'm trying to create a true statement if the due date is 2 months in the future. I have tried to formula below but it's not working. Any suggestions?

=IFERROR(IF([Due Date]@row > DATE(YEAR([Due Date]@row), MONTH(TODAY() + 1), DAY([Due Date]@row)), true, false), (IF([Due Date]@row > DATE(YEAR([Due Date]@row), MONTH(TODAY() - 11), DAY([Due Date]@row)), true, false)))

Find more posts tagged with

Accepted answers

All comments

John_Foster

Hi @frob,

This formula should do the trick.

=IF([Test Date]@row > DATE(IF(MONTH(TODAY()) = 11, YEAR(TODAY()) + 1, IF(MONTH(TODAY()) = 12, YEAR(TODAY()) + 1, YEAR())), IF(MONTH(TODAY()) = 11, 1, IF(MONTH(TODAY()) = 12, 2, MONTH(TODAY()) + 2)), DAY(TODAY())), 1, 0)

Hope it helps!

John

frob

Unfortunately, that did not work. My Feb due dates are still showing as false.

John_Foster

Hi @frob,

That's odd, I tested it on a February date and it shows as ticked in mine. I am using a 1 or 0 rather than True or False though.

John_Foster

Hi @frob,

Please find below a link to my sheet with the working formula, feel free to take a look and see if it helps

https://app.smartsheet.com/b/publish?EQBCT=4681e37590ab4b9e8251951da93211ce

Thanks,

John

frob

Got it to work. There was just one true false statement that was off. Thank you for all the help!!

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.