Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY
iam trying to find out the number of years, months and days an employe worked
in the company and iam trying to find it out by subratcting Joining date from retirement date and i want the result something like this 25 years 3 months and 8 days. is the total working period of the employee in the company. For ex : Joining Date : 20 /1 /2000 Retirement Date : 22 /2 /2001 Then the Total working Period of the Employee is : 1 Year 1 Month and 2 days I want to know how I can calculate it by using formula |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
Find project start and end dates in a DB with many different proje | Excel Worksheet Functions | |||
Find (Today-21) in a range of dates | Excel Discussion (Misc queries) | |||
Find number of days between to dates | Excel Worksheet Functions | |||
Formula to find information between 2 dates | Excel Worksheet Functions |