Vehicle age

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
 
F

Fred Smith

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

Marty

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Next Available Sequence Number 1
Calculate Age 3
Average Age 8
Earliest/Latest Date Query 10
Mail-Merge with Varying Data-Ranges 1
Age Calculation 3
making age group query work 7
Crosstab Query Questions 5

Top