Forum Discussion
Formula for tracking ages.
Hello Everyone, I'm trying to figure out how to incorporate an Excel formula that tracks the age of four people for each of their respective transactions. In other words, I need to know the spender...
Michael_OConnor If you could create a small table with the four individuals' names and birth dates, you can use VLOOKUP (or perhaps XLOOKUP if your Excel version supports it) to lookup the birth date "belonging" to each transaction. Next, deduct the birth date from the transaction date and divide by 365. Format the column with the result as a number. Then, you'll end up with the (approximate) age, of the individual at the date of the transaction. Perhaps a bit rough, but I don't know how accurate you want it to be.
- Riny_van_Eekelen Excellent, thank you. I will give that a try.
