Help w/adding NETWORKDAY - formula not working
Hi team - I have an automated date column called 0. DDO Assigned (actual) that records a date from a status change in another column. I want to add 4 working days to that date as a "bench mark" in the 1. Pending 3PRM Refresh/Aggregate IRQ (BM) column. I tried using the following formula and, while it does not error out, it does not add the 4 days in the 1. Pending 3PRM Refresh/Aggregate IRQ (BM) column (changed column property from Text to Date and still doesn't work):
=IFERROR(NETWORKDAY([0. DDO Assigned (actual)]@row, 4), "")
What am I doing wrong?
Best Answer
-
I believe you have the right logic but the wrong function. NETWORKDAY returns the number of working days between two dates. You don't want that, you want the date for something that is 4 working days away from your original date. I think you should use WORKDAY instead. Something like this should work:
=IFERROR(WORKDAY([0. DDO Assigned (actual)]@row, 4), "")
Answers
-
I believe you have the right logic but the wrong function. NETWORKDAY returns the number of working days between two dates. You don't want that, you want the date for something that is 4 working days away from your original date. I think you should use WORKDAY instead. Something like this should work:
=IFERROR(WORKDAY([0. DDO Assigned (actual)]@row, 4), "")
-
That worked @David Tutwiler !
Thought I tried WORKDAY earlier and it errored - guess I just needed to try it again after your recommendation.
-
No problem, glad it's working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!