I need an expression that will help me list all items that will be of age 20 years in the 2007 calendar year. Currently have Year of manufacture. How can I do this without exporting all records to excel and then calculating?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Age Calculation
- Thread starter ajm
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Hi Andrew,
Build a query that includes the item ID, Name, and Year of Mfr (and any other fields that you want to display)
In the Criteria row for Year of Mfr, enter 1987.
Denis
Build a query that includes the item ID, Name, and Year of Mfr (and any other fields that you want to display)
In the Criteria row for Year of Mfr, enter 1987.
Denis
Upvote
0
Similar threads
- Question
- Solved
