dhanraj, have a look here,

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

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