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
Any help is appreciated. bob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=(NOW()-A1)/365.25
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
excellent thank you both
You can copy that formula down the column....
barry