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
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