Calculate future date according to criteria met but only workdays

Hi! I'm using this formula:

=IF(ISDATE(Date@row), IF(Level@row = "1", (Date@row + 2), IF(Level@row = "2", (Date@row + 3), IF(Level@row = "3", (Date@row + 4)))))

With each level there'll be certain criteria:

Level 1 = 2 days

Level 2 = 3 days

Level 3 = 4 days

The formula is actually correct but it includes weekends. Therefore I would like to include the WORKDAY formula but couldn't find the right way to match them as I only want to calculate our working day.

Thank you in advance!

Find more posts tagged with

Accepted answers

All comments

KPH

Instead of

(Date@row + 2)

you can use

WORKDAY(Date@row, 2)

This adds two working days to Date@row

I hope that helps.

Farhana

Hi @KPH ! Tried adding them like this

=IF(ISDATE(Date@row), IF(Level@row = "1", (WORKDAY(Date@row + 2)), IF(Level@row = "2", (WORKDAY(Date@row + 3)), IF(Level@row = "3", (WORKDAY(Date@row + 4))))))

But it became Inaccurate Argument Set instead.

Example of my columns

KPH

Not

date@row plus 2

use

date@row comma 2

like this

WORKDAY(Date@row, 2)

KPH

Hi @Farhana

Were you able to make the change? Is the formula working for you now?

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.