Vehicle age

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

Hello people

Hey guys I have been tasked to produce a spread sheet that shows two things:
Vehicle age and average age of all the vehicles.
I have a spreadsheet with all the vehicle details including the purchase
date, but I need to know how old the vehicleswill be individually next year
and every year until 2020 plus the average age of each vehicle and all
vehicles at any given date.
Any help is always welcome. TA
 
It depends how accurate you want to be. If age in years is good enough, use
Datedif, as in:
=datedif(a1,a2,"y")
Then average these results.

If you need to be completely accurate, use the age in days. Just subtract
the two dates, to get the number of days difference, as in:
=a2-a1
Then average these results.

Regards,
Fred.
 
Thanks Fred.

Fred Smith said:
It depends how accurate you want to be. If age in years is good enough, use
Datedif, as in:
=datedif(a1,a2,"y")
Then average these results.

If you need to be completely accurate, use the age in days. Just subtract
the two dates, to get the number of days difference, as in:
=a2-a1
Then average these results.

Regards,
Fred.
Click to expand...
 
Back
Top