Past Due, 1 to 30 days , 31 to 60 days & 61 to 90 days

Hi Team,

I have a "Planned start date" column , I need data for Past Due, 1 to 30 days , 31 to 60 days & 61 to 90 days in once cell, could you help.

=IF(TODAY() > [Planned Start Date]@row, "Past Due", IF([Planned Start Date]@row <= TODAY(1-30), "Start < 30 Days"))

Out comes : "Past Due" "Start < 30 Days" "Start between 31 to 60 Days" & "Start between 61 to 90 Days"

Regards,

Mukund

Find more posts tagged with

Accepted answers

Mukundraj

I somehow found the formula

=IF([Planned Start Date]@row < TODAY(), "Past Due", IF([Planned Start Date]@row <= TODAY(30), "Start < 30 Days", IF([Planned Start Date]@row <= TODAY(60), "Start between 31 to 60 Days", IF([Planned Start Date]@row <= TODAY(90), "Start between 61 to 90 Days", ""))))

All comments

Mukundraj

I somehow found the formula

Genevieve P.

Hi @Mukundraj

Thanks for posting your solution! I'm glad you were able to figure it out.

Cheers,

Genevieve

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.