This site will also show how to calculate the difference between years,
months, and days:

http://www.pdbook.com/index.php/excel/date_differences/

----
Regards,
John Mansfield
http://www.pdbook.com

"srinivasa rao" wrote:

i would like to know to how to calculate year,month and date between to dates
Example
01/10/1977 and 10/04/2002 . i want to know the formula for getting correct
years, months and days between above dates