How do I calculate an age from 2 dates?
 

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

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

--

HTH

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


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

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


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

Assuming The Dob Is In Cell B15

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


R


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=392346