Calculate future date according to criteria met but only workdays

Farhana

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!

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?