Link to home
Start Free TrialLog in
Avatar of goldmineexpert
goldmineexpert

asked on

calculate age from excel field

I have a excel file with a column of birthdays and would like to create another column next to it with the actual age of the person. Two decimal points would be nice if possible

Any help is appreciated.  bob
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
...sorry, of course I meant with DOB in A2.....

You can copy that formula down the column....

barry

=(NOW()-A1)/365.25
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of goldmineexpert
goldmineexpert

ASKER

excellent thank you both