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.

excel update current age of customer in table

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.

excel update current age of customer in table


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?


Here the previous and next chapter