Past Due Date in Business Day Formula

Hi! I have a formula I have been trying to figure out. I'm getting stuck because I want to make sure that the duration does not include weekends or holidays (if possible) and there is a condition.
Any help would be appreciated.
I would like to know how many business days past due a project is from today, but only if feedback received date has not been filled out.
Answers
-
Hi @Laura A
You can use the NETWORKDAY formula to get the working days between two dates. If the project is yet to be completed, you can still use the NETWORKDAY formula and use TODAY as the end date and Requested Due Date as the start date to get continuous aging.
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!