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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!