calculating age from date of birth
 

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.

calculating age from date of birth
 

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)

"Tim" wrote in message
...
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.

calculating age from date of birth
 

Hi Tim!

Also see:
http://tinyurl.com/2mn4h

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.