Excel Help

alex_boothby

In Runtime
Messages
317
Hi Guys,

Hoping someone who is a whiz at excel can help.

So I want to find out yearly mileage increases of my car. I have ten years of mileage entries, but they are at random times a year an not one year apart each time.

Is there a way I can get excel to calculate a estimated annual mileage for each year?

I'm guessing I could just plot a graph and use a trend line and pick out the same time of year, but I'm sure there is a smarter way!

I tend to come across this problem a lot!

Here is my data if that helps

I'm hoping this makes sense....

Mileage Date
10168 04/09/2007
19906 05/03/2008
30601 01/10/2008
40405 05/10/2009
40577 08/10/2009
49782 05/07/2010
50434 27/07/2010
54499 09/06/2011
68732 31/05/2012
83197 17/12/2014
90225 11/12/2015
95623 23/02/2016
 

root

Site Team
Staff member
Messages
8,181
Location
UK
you can just subtract dates in the format that you have to get a day count.

e.g 23/02/2016-11/12/2015 = 74

or more appropriatly
23/02/2016 - 04/09/2007 = 3094 (days)
3094 days / 365 = 8.47 years

95623 - 10168 = 85455

85455 miles / 8.47 years = 10081.15 miles per year average
 
Messages
963
Location
US
you can just subtract dates in the format that you have to get a day count.

e.g 23/02/2016-11/12/2015 = 74

or more appropriatly
23/02/2016 - 04/09/2007 = 3094 (days)
3094 days / 365 = 8.47 years

95623 - 10168 = 85455

85455 miles / 8.47 years = 10081.15 miles per year average
This method will only show an average, but not show if there is a year over year increase, ie "I drove twice as far in 2006 compared to 2005"...etc.
 
Top