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.

"Marty" wrote in message
...
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

Thanks Fred.

"Fred Smith" wrote:

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.

"Marty" wrote in message
...
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