update current age of customer in table in Excel

Q96. I have a large list of clients whose current Age I need to maintain in my database as it influences costs - how can I have Excel display the current age at all times?

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 excel update current age of customer in table


You can find similar Excel Questions and Answer hereunder

1) How can I ensure that important files always appear on the recent Excel workbooks list?

2) How to concatenate strings in vba in Excel

3) How do I update my DropDown list whenever the sheet is activated?

4) I frequently use a Macro - is there a way to quickly access the Macro in the Excel Ribbon?

5) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

6) Can I change the way that huge numbers are displayed in Y-Axis so that they do not take up chart space?

7) To easily identify sheets belonging to different Business Divisions, I would like to color code tab names - is it possible?

8) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

9) 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?

10) How can I display list of NAMES in a worksheet?

11) How can I get the last non-zero value in a row?

12) I am a construction Engineer. Considering a room with dimension, 14ft x 12ft can I find the side of the largest square tile which can tile the room?

13) Filtering the value field in a pivot table in Excel

14) How can I update a listbox based on data in a list using VBA?

15) Userform initialize vs userform show in Excel