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

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

Attached Files
Membership is required for download. Create An Account First
File Type: xls Date Calculation.xls (32.5 KB, 1295 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
From India, Mumbai
Dear All, Please find the attached one another Date Diffrence formula file..
From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls Date difference formula.xls (31.5 KB, 924 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
From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: xls calculation of Age.xls (32.0 KB, 527 views)

Reply (Add What You Know) Start New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2017 Cite.Co™