Update current age of customer in table in Excel
In the Table below, I would like to see the current Age updated automatically in col AU.
To do it in Excel, here is the answer:
a) Enter the formula =INT(YEARFRAC(AT3,TODAY(),1)) for first client as shown below. Drag the formula to rest of the client column.
TODAY() function used in formula always corresponds to the current date.
YEARFRAC function determines the years since Date of Birth (till date represented by Today()). Third argument "1" defines" normal year calculation (not 360 days).
Since Age corresponds to number of full years, INT function is used to wrap the YEARFRAC function.
You can find similar Excel Questions and Answer hereunder
1) Filtering the value field in a pivot table in Excel
2) Can I add a small chart to Table data to make it visually appealing and easy to interpret?
3) How can I declare a variable in VBA, what is important to declare
4) I have to retrieve data from a specific column in a Table. In Excel, how can I do that?
5) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?
6) How to use data table function in Excel. It helps you go through various scenario when seeking a goal
7) How can I avoid updates to cell values during macro execution?
8) How can I update a listbox based on data in a list using VBA?
9) Tables in Excel VBA. How you can create table in VBA and work with them with macros
10) How do I update my DropDown list whenever the sheet is activated?