DHANRAJ Wrote:
I am entering Date of birth in a cell and i would like to calculate age
in
another cell. how to do about it ?

=DATEDIF(A1,B1,"Y")

Syntax

DATEDIF(start_date,end_date,unit)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=529972