rupa.gurav
1

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
Amit Insha
29

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, 1380 views)

rupa.gurav
1

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
Amit Insha
29

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, 1006 views)

rupa.gurav
1

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, 600 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.