workday calculation with if conditions

edited 12/09/19 in Formulas and Functions


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!