Calculate Working days with Multiple If Conditions

tamiz.vedachalam

I have a scenario to calculate due dates with the following logic.

LOW - Greater than - 7 days

MEDIUM - Greater than - 4 days

HIGH - Greater than - 2 days

CRITICAL - Greater than - 1 day

I have written the formula like this

example - Low 7 days -

Request Created On - 04/01/2024 will achieve the output date as 04/07/2024. But I need to calculate the working days or weekdays.

=IF(Severity@row = "Low", [Request Created On]@row + 7, IF(Severity@row = "Medium", [Request Created On]@row + 4, IF(Severity@row = "High", [Request Created On]@row + 2, IF(Severity@row = "Critical", [Request Created On]@row + 1))))

Find more posts tagged with

Reports

Accepted answers

Kelly Moore

Hey @tamiz.vedachalam

The WORKDAY function calculates workdays.

=IF(Severity@row = "Low", WORKDAY([Request Created On]@row, 7), IF(Severity@row = "Medium", WORKDAY([Request Created On]@row, 4), IF(Severity@row = "High", WORKDAY([Request Created On]@row, 2), IF(Severity@row = "Critical", WORKDAY([Request Created On]@row, 1)))))

Will this work for you?

Kelly

tamiz.vedachalam

Yes it worked. Thank you for the help

All comments

Kelly Moore

Hey @tamiz.vedachalam

The WORKDAY function calculates workdays.

Will this work for you?

Kelly

tamiz.vedachalam

Yes it worked. Thank you for 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.