hello!



I have a list/column of dates in 30/01/1949 format which are birth dates
I want to calculate the age of each person

how can I do it?

thanks!

In A2 for example put a persons DOB i.e 13/08/1969 then in B2 enter

=DATEDIF(A2,TODAY(),"y")&" years "&DATEDIF(A2,TODAY(),"ym")&" months "&DATEDIF(A2,TODAY(),"md")&" days"

Copy down as needed.


The result will show the difference from the current date to include the number of years, months and days. The best news is that you don't have to update the formula if you open the file at a later date; the age will automatically recalculate based on the current date.

I get "the formula you typed contains an error :/

Works fine for me

Look at this

Attached Files

Book1.xls (13.5 KB, 10 views)

the format of the dates is different, maybe this is the problem?

is it possible to make a function that will work with any date formats?

This is the format for the date you specified, this is UK date format is that what you want?

the format I want is dd/mm/yyyy

It does not matter the way the date is formatted as. Whether it is dd/mm/yyyy or mm/dd/yyyy the answer will still be the same. Please attach a sample workbook with what you have input so I can take a look.