workday calculation with if conditions
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
Check out the Formula Handbook template!