Thread Started by #rupa.gurav

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
24th January 2011 From India, Mumbai
Dear Rupa, Find the attached sheet, Hope that is helpful for you....
24th January 2011 From India, Delhi

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

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

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

Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information and resources for business and professional growth. Register Here
Prime Sponsor: TALENTEDGE - Certification Courses from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2017 Cite.Co™