Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEDIF function in excel
i have to find out how many years employee has been working on the job. using
current date - hire date/365. result have to be in years? who knows the right function, so i can get the answers for all employees at one time? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEDIF function in excel
You are close:
=(current date - hire date)/365.25 Just switch the dates around and wrap them in ()s and you are set. Copy the formula down to all your records. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Rosa" wrote: i have to find out how many years employee has been working on the job. using current date - hire date/365. result have to be in years? who knows the right function, so i can get the answers for all employees at one time? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEDIF function in excel
and using datedif
=DATEDIF(A1,TODAY(),"y") and with months =DATEDIF(A1,TODAY(),"y")&" Years "&DATEDIF(A1,TODAY(),"ym")&" Months" Mike "Rosa" wrote: i have to find out how many years employee has been working on the job. using current date - hire date/365. result have to be in years? who knows the right function, so i can get the answers for all employees at one time? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEDIF function in excel
Use DATEDIF(startdate,TODAY(),"y")
Change the last argument as below m Months d Days y Years ym Months Excluding Years yd Days Excluding Years md Days Excluding Years And Months If this post helps click Yes --------------- Jacob Skaria "Rosa" wrote: i have to find out how many years employee has been working on the job. using current date - hire date/365. result have to be in years? who knows the right function, so i can get the answers for all employees at one time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Datedif function | Excel Discussion (Misc queries) | |||
DATEDIF FUNCTION | Excel Worksheet Functions | |||
Please add reference to the Excel function DATEDIF to your help | Excel Discussion (Misc queries) | |||
The 'DATEDIF' Function is not listed on my Excel program. | Excel Worksheet Functions | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions |