Formula for ages from DOBs needed.

[calcatron]

I am doing a statistics project and have collected numerous dates o
birth. However I do not know how to automatically calculate their age
from a set date. ie 29/01/04 whilst retaining the original data
It is pretty urgent so if you have any idea ..

 

[Paul]

I am doing a statistics project and have collected numerous dates of
birth. However I do not know how to automatically calculate their ages
from a set date. ie 29/01/04 whilst retaining the original data
It is pretty urgent so if you have any idea ...

It's all described here:
http://www.cpearson.com/excel/datedif.htm#Age

 

[Roger Govier]

Hi

With your dates in column A try entering in B1
=DATEDIF(A1,"29/01/2004","y")
Copy down column B

 

[Norman Harker]

Hi calcatron!

See:
http://tinyurl.com/2mn4h

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.