What Excel function uses information from the date of the birth column to calculate age in the age column?

The date of birth is entered in Column D of a table for customers, and the age is entered in Column H; How can I utilize the Date of Birth in Column D and a function or formula in Excel to automatically determine Age in Column H?
Mar 28, 2023 in Others 368 views

## 1 answer to this question.

Try

`=INT((YEARFRAC(TODAY(),B3,1)))`

Where cell B3 contains a date like 01/01/1970 will return age in years.

• 38,010 points

## Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

## Is there a function to unhide columns in excel through python

Excel file : df.to_excel('demofile.xlsx',index=False) import openpyxl py = openpyxl.load_workbook('demofile.xlsx') exlsheet = ...READ MORE

## Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE