Assuming that A1 contains the birthday:
=DATEDIF(A1,NOW(),"y")

For more information on DATEDIF have a look at your *very* old Excel
documentation (yes, Excel once came with printed handbooks) or look
hehttp://www.cpearson.com/excel/datedif.aspx

Cheers,

Joerg Lefeber



"harsh_njoy" wrote in message
...
Hi,

how we can calculate present age if date of birth is given say for eg:
21/2/1983

Thanks