how to calculate years, months by using one formula
 

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

Use the undocumented function DATEDIF
See Chips site for details www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

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