Formula to add 30 days to "Date notified" AND countdown the days until that Date notified + 30 days

I was able to set a formula to add 30 days to Date notified:

=[Date notified]@row + 30

Then set another formula to count down the days from the Date notified + 30 days:

=IF([Date notified + 30 days]@row < TODAY(), "", NETDAYS(TODAY(), [Date notified + 30 days]@row))

The 2nd formula I have also results in a blank result once the Date notified + 30 days has passed.

How can I combine the formulas to 1 formula so that I could get rid of the "Date notified + 30 days" column and only have the countdown of 30 days from the Date notified?

In another formula, how can I change the countdown formula to include negative days if we are past the countdown but the date hasn't been closed yet? But also for it to give a blank result once it's closed?

Below is an example with random dates:

Find more posts tagged with

Accepted answers

All comments

JamesB

@vivian123 I believe this will do what you want.

=IF(NOT(ISDATE([Date Closed]@row)), [Date Notified]@row + 30 - TODAY(), " ")

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.