Computer Forums Excel Help
 Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Log in

 Thread Tools Search this Thread Display Modes

 09-29-2016, 11:45 AM #1 In Runtime     Join Date: Apr 2005 Posts: 314 Excel Help 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 __________________ __________________
 09-29-2016, 12:06 PM #2 Site Team     Join Date: Mar 2004 Posts: 8,107 Re: Excel Help 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 __________________ __________________ I didn’t fight my way to the top of the food chain to be a vegetarian… Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns. "The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
09-29-2016, 07:09 PM   #3
BSOD

Join Date: Feb 2016
Location: US
Posts: 963
Re: Excel Help

Quote:
 Originally Posted by root 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.
__________________

 Tags excel, stats

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules