workday calculation with if conditions
Hi,
I'm trying to add a workday function to my current calculation. I already use if condition in the cell. Here's what I have.
If location is Riverside, then add 3 days to ETA. If location is Memphis, then add 5 days to ETA.
IFERROR(IF(Location1 = "RIVERSIDE", ETA1 + 3, IF(Location1 = "MEMPHIS", ETA1 + 5)), 0)
However, I need the dates that come out to be weekday/working day and exclude weekends. Appreciate all the help.
Thanks!
Comments
-
Hi Teddy -
You could insert a WORKDAY function into the formula -
=IFERROR(IF(LOCATION2 = "RIVERSIDE", WORKDAY(ETA2, 3), IF(LOCATION2 = "MEMPHIS", WORKDAY(ETA2, 5))), 0)
This will move the new date to the following Monday (or day after holiday if that is defined) if it falls on a weekend. See https://help.smartsheet.com/function/workday
I hope this helps?
Sean
Help Article Resources
Categories
Check out the Formula Handbook template!