How do I calculate an age from 2 dates?

[Guest]

Ineed to calculate an age from a given date of birth calculated to the
current date. Should the birthday pass the current date then the age should
also change

 

[Bob Phillips]

Se http://www.cpearson.com/excel/datedif.htm#Age

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ron de Bruin]

See Chip's site about this
http://www.cpearson.com/excel/datedif.htm

 

[Ruthki]

Assuming The Dob Is In Cell B15

=datedif(b15,now(),"y")


R