Dear All,
I need your help to understand how to calculate the difference between the two dates in Excel using formulas.
Example:
Date of joining the company: 1/11/2009
Today's Date: 24/1/2011
It should give the answer as 1 Year, 2 months, 23 days.
Looking forward to your reply on the same.
Thanks & Regards,
Rupa Gurav
From India, Mumbai
Acknowledge(0)
Amend(0)
1I need your help to understand how to calculate the difference between the two dates in Excel using formulas.
Example:
Date of joining the company: 1/11/2009
Today's Date: 24/1/2011
It should give the answer as 1 Year, 2 months, 23 days.
Looking forward to 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
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Amit,
Thank you for sharing the information. Could you please tell me the formula you use to calculate an exact age? I am eager to learn from you.
Thanks and Regards,
Rupa Gurav
Asst. Manager HR
Mumbai
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you for sharing the information. Could you please tell me the formula you use to calculate an exact age? I am eager to learn from you.
Thanks and 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
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.