Calculate average durations between dates
I have an original sheet with hundreds of rows of information (Source Sheet) that I am looking to summarize calculations in to a second sheet (Summary Sheet), in order to feed in to a dashboard. Source Sheet has two date fields that I am interested in - lets refer to them as an 'open' and 'close' date.
I would like to calculate the average duration between open and close for the entire sheet.
Is there a calculation that can accommodate this directly in to the Summary Sheet? Without having to calculate the duration between open and close for each record in the Source Sheet? My sheet is large as it is, and would prefer to not expand, if possible.
Appreciate the help - can't seem to find exactly what I'm looking for in the community.
Best Answer
-
Unfortunately not. You would need to have the actual duration calculated on the source sheet before you could pull the average.
Answers
-
Forgot to include that some of the date fields may be blank or include 'N/A' text within the cell - so this would need to be considered as well.
-
Unfortunately not. You would need to have the actual duration calculated on the source sheet before you could pull the average.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 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!