Average formula with weekends excluded
Hello All,
I need to tweak a very simple formula. Currently i have this '="Average Resolution Time - " + AVG([Time Taken to Complete]33:[Time Taken to Complete]148) + " Days" ' but i really need something that only averages workdays within that time period. Be very glad i any suggestions. I started experimenting with the =workday formula but haven't been successful as yet!
Thanks for you assistance in advance!
Comments
-
How are you calculating the Time Taken to Complete column values? If you are getting them from subtracting a Start Date from an End Date, then you can use the NETWORKDAYS function instead:
=NETWORKDAYS([Start Date]1, [End Date]1)
Then your formula above should work as is.
-
Thanks Lauren, that's perfect!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!