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))))

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

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