Calculating Net Days with multiple dates
I have THREE columns each has a date that is auto populated when another columns checkbox is checked as an action has been completed. I want to create a formula that calculates NETDAYS for ALL THREE columns dates when all have had dates auto populated into them.
Example: Column 1 = Date a resume was reviewed; Column 2 Date Licensure was reviewed; Column 3 Date a contract was reviewed. Final formula will calculate NETDAYS it took for all three of these actions to be completed based on the dates of each of these columns
Answers
-
try something like this, make sure the columns are in the same order
=NETDAYS(MIN([Date resume reviewed]:[Date Contract reviewed]), MAX([Date resume reviewed]:[Date Contract reviewed]))
-
Paul thank you for looking into this. When I enter the formula above it wants to capture several rows within the formula vs just the row that I am on. Should I be including @row in the formula to instruct the formula to ONLY be calculating the netdays for the columns I calling out for the row I am on?
-
Sorry you would need to add the row number, then drag the formula down
=NETDAYS(MIN([Date resume reviewed]1:[Date Contract reviewed]1), MAX([Date resume reviewed]1:[Date Contract reviewed]1))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!