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!
Answers

Instead of
(Date@row + 2)
you can use
WORKDAY(Date@row, 2)
This adds two working days to Date@row
I hope that helps.

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

Not
date@row plus 2
use
date@row comma 2
like this
WORKDAY(Date@row, 2)

Hi @Farhana
Were you able to make the change? Is the formula working for you now?
Help Article Resources
Categories
Check out the Formula Handbook template!