NETWORKDAYS Formula < =NETWORKDAYS(MAX({Range}), TODAY()) >
=NETWORKDAYS(MAX({Range}), TODAY())
With the formula listed above I am attempting to find the difference in workdays between two dates. The MAX function is pulling the latest date from a column in another sheet. The TODAY function is referencing the current date.
If the date discovered with the MAX function is todays date (example: TODAY = June 27th and MAX = June 27th) will the NETWORKDAYS formula produce "0" or "1"? Currently, my formula produces 1, but I believe it should show 0.
Best Answer
-
To answer your question, the formula in your post would result in a returned value of 1 if the max date found was today's date. The formula is working as intended. If you do not want to count today as a day, then change your formula to:
=NETWORKDAYS(MAX({Range}), TODAY()) -1
Answers
-
To answer your question, the formula in your post would result in a returned value of 1 if the max date found was today's date. The formula is working as intended. If you do not want to count today as a day, then change your formula to:
=NETWORKDAYS(MAX({Range}), TODAY()) -1
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!