Duane, I wish that simple solution were true, but it does not seem to be. My sample dates: 5/12/04, 1/28/04, 9/28/03.
Using your method, (5/12/04 - 9/28/03)/3 = 75.67.
Actual results: 5/12/04 - 1/28/04 = 105
1/28/04 - 9/28/03 =122
Avg(105,122) = 113.5...
Access newbie here. I've got a query that pulls a series of dates. I need to calculate the average interval between the dates. Any help would be greatly appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.