Question about Workday Formula
Hi there - I'm looking for some assistance with a WORKDAY Formula. I am trying to:
- Look at a date in a cell - let's call that "Program Date" and add 12 days to that date
- Then reference another sheet that has a column of dates and pull back the earliest date (that's later than Program Date plus 12 days)
- Exclude holidays
I feel like I'm so close but I've got it opposite of what it needs to be and I can't figure out what needs to change.
Here's the formula I have that's wrong
=IFERROR(WORKDAY((MIN(COLLECT(Meeting Date OG}, {Meeting Date OG}, >=(Date37 + 12)))), 0, {State Holidays OG}), "")
Where {Meeting Date OG} is the column I'm looking at to pull back the date and Date37 is the "Program Date"
Any help you can offer is appreciated!
Answers
-
This seems to work for me. I think what was happening is since you were passing only 1 date to the workday function (the min date), and using zero for the number of days, it was not checking the holiday exclusions. Here I have deducted 1 day from your 12 day parameter and passed a 1 day duration to the workday function to make up the difference.
=IFERROR(WORKDAY((MIN(COLLECT({Meeting Date OG}, {Meeting Date OG}, >=([Column11]@row + 11)))), 1, {State Holidays OG}), "")
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!