calculating age from date of birth

[Tim]

Is there a formula or a way to calculate age from the date
of birth, if the date of birth is entered as; 12Jan82?
I would like to enter the date of birth, as above, and have
the age automatically displayed in another cell.

 

[Bob Phillips]

Tim,

Take a look at Chip Pearson's site at
http://www.cpearson.com/excel/datedif.htm There is a section on Calculating
a person's age.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Norman Harker]

Hi Tim!

Also 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.