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

From India, Mumbai
Acknowledge(0)
Amend(0)

Dear Rupa, Find the attached sheet, Hope that is helpful for you....
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls Date Calculation.xls (32.5 KB, 1404 views)

Acknowledge(0)
Amend(0)

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

From India, Mumbai
Acknowledge(0)
Amend(0)

Dear All, Please find the attached one another Date Diffrence formula file..
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls Date difference formula.xls (31.5 KB, 1022 views)

Acknowledge(0)
Amend(0)

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

From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls calculation of Age.xls (32.0 KB, 611 views)

Acknowledge(0)
Amend(0)

Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.