workday calculation with if conditions

teddy89491 · 05/21/19

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!

sean59916 · 05/21/19

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

Comments