imapoboy2
New member
- Joined
- Jul 2, 2013
- Messages
- 12
- Reaction score
- 0
- Points
- 1
- Age
- 56
- Location
- Wisconsin
- Excel Version(s)
- 2013
I have a report that shows a list of vehicles by Year of Manufacturing. I need a formula that will calculate the average age of listed vehicles from the current date.
A2 = 1995, A3 = 2003, A4 = 2011, etc... Today's date is 07-01-2013, I need the average age in Years form todays date. I hope this makes sense.
A2 = 1995, A3 = 2003, A4 = 2011, etc... Today's date is 07-01-2013, I need the average age in Years form todays date. I hope this makes sense.