Forum Discussion
Solved
Age calculation
I have a list of dates of birth from a membership spreadsheet. Is there a formula to give me ages of members against current date? Thanks in advance.
Hi Richard,
You can use the DATEDIF function as follows:
=DATEDIF(A1,TODAY(),"Y")
Where cell A1 is the birthdate.
Hope that helps
Could you share screenshot or sample file, and what exactly means "not work"?
SergeiBaklan I had existing data ranges filled out with birth dates in them. I wanted the year first and tried formatting this way but the changes never occurred. After giving up on that I still wanted to figure out current age and since I will be looking at this file for years to come I would like it to update automatically. What function do I use to do this? Thanks
As variant birthdays are entered as texts which looks as dates, not as values which Excel recognize as dates for your regional settings. Whatever. Why don't you share small sample file?