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(1)
Amend(0)
From India, Delhi
Acknowledge(1)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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt