How To Calculate The The Difference Between Two Dates

Dear All,
Need your help to understand how tocalculate the difference between the two dates in Excel using formulas.
Example:
Date of joining to the company : 1/11/2009
Todays Date : 24/1/2011
It should gives the answer as 1 Year, 2 months, 23 days.
Looking forward for your reply on the same.
Thanks & Regards
Rupa Gurav
24th January 2011 From India, Mumbai

Dear Rupa, Find the attached sheet, Hope that is helpful for you....
24th January 2011 From India, Delhi

Attached Files (Download Requires Membership)

Date Calculation.xls (32.5 KB, 1352 views)

Dear Amit,
Thanks a lot for sharing the nformation.
can you tell me, what is the formula that you put to calculat an exact age.
wanted to learn from you.
Thanks & Regards
Rupa Gurav
Asst. Manager HR
Mumbai
25th January 2011 From India, Mumbai

Dear All, Please find the attached one another Date Diffrence formula file..
26th January 2011 From India, Delhi

Attached Files (Download Requires Membership)

Date difference formula.xls (31.5 KB, 994 views)

Dear Amit,
Thanks for sharing the calculation of difference between two dates.very usefull information
Please find an attached modified formula using your document as the base.
Thanks & Regards
Rupa Gurav
Asst. Manager-HR
28th January 2011 From India, Mumbai

Attached Files (Download Requires Membership)

calculation of Age.xls (32.0 KB, 582 views)