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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!