|
Function to calculate the Length of Service of an Employee
Hi there,
I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne |
Function to calculate the Length of Service of an Employee
=DATEDIF(A1,A2,"y")
Where A1= date of hire, and A2=date of reference (could be TODAY() for example). -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Grd" wrote: Hi there, I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne |
Function to calculate the Length of Service of an Employee
Try
=DATEDIF(A1,TODAY(),"y") Mike "Grd" wrote: Hi there, I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne |
Function to calculate the Length of Service of an Employee
If your hire date is in D2, try this:
=INT((TODAY()-D2)/365) and then copy down. This does not account for leap years - is that important to you? Hope this helps. Pete On Nov 10, 4:26*pm, Grd wrote: Hi there, I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne |
Function to calculate the Length of Service of an Employee
Works thanks.
=INT((TODAY()-D2)/365.25) I added the .25 for leap years "Pete_UK" wrote: If your hire date is in D2, try this: =INT((TODAY()-D2)/365) and then copy down. This does not account for leap years - is that important to you? Hope this helps. Pete On Nov 10, 4:26 pm, Grd wrote: Hi there, I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne |
Function to calculate the Length of Service of an Employee
Okay, thanks for the feedback.
Pete On Nov 10, 5:13*pm, Grd wrote: Works thanks. =INT((TODAY()-D2)/365.25) I added the .25 for leap years "Pete_UK" wrote: If your hire date is in D2, try this: =INT((TODAY()-D2)/365) and then copy down. This does not account for leap years - is that important to you? Hope this helps. Pete On Nov 10, 4:26 pm, Grd wrote: Hi there, I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne- Hide quoted text - - Show quoted text - |
Calculating Years of Service
Out of all the samples I have tried the one below is the only one I could get to work.
However, I am trying to calculating the years, months and days and was wondering if you have something for that? Thanks Vivian Gr wrote: Works thanks.=INT((TODAY()-D2)/365.25)I added the . 10-Nov-08 Works thanks. =INT((TODAY()-D2)/365.25) I added the .25 for leap years "Pete_UK" wrote: Previous Posts In This Thread: On Monday, November 10, 2008 11:26 AM Gr wrote: Function to calculate the Length of Service of an Employee Hi there, I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne On Monday, November 10, 2008 11:30 AM john wrote: =DATEDIF(A1,A2,"y")Where A1= date of hire, and A2=date of reference (could be =DATEDIF(A1,A2,"y") Where A1= date of hire, and A2=date of reference (could be TODAY() for example). -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Grd" wrote: On Monday, November 10, 2008 11:30 AM Mike wrote: Function to calculate the Length of Service of an Employee Try =DATEDIF(A1,TODAY(),"y") Mike "Grd" wrote: On Monday, November 10, 2008 12:13 PM Gr wrote: Works thanks.=INT((TODAY()-D2)/365.25)I added the . Works thanks. =INT((TODAY()-D2)/365.25) I added the .25 for leap years "Pete_UK" wrote: On Wednesday, November 12, 2008 3:40 AM Pete_UK wrote: Function to calculate the Length of Service of an Employee If your hire date is in D2, try this: =3DINT((TODAY()-D2)/365) and then copy down. This does not account for leap years - is that important to you? Hope this helps. Pete a pany On Wednesday, November 12, 2008 3:40 AM Pete_UK wrote: Function to calculate the Length of Service of an Employee Okay, thanks for the feedback. Pete was a company EggHeadCafe - Software Developer Portal of Choice Insert Flash into PowerPoint 2007 http://www.eggheadcafe.com/tutorials...o-powerpo.aspx |
Calculating Years of Service
Have a look at what Chip has about Datedif
http://www.cpearson.com/excel/datedif.aspx One example gives 12 years 8 months 14 days best wishes Bernard Liengme "Vivian Baker" wrote in message om... Out of all the samples I have tried the one below is the only one I could get to work. However, I am trying to calculating the years, months and days and was wondering if you have something for that? Thanks Vivian Gr wrote: Works thanks.=INT((TODAY()-D2)/365.25)I added the . 10-Nov-08 Works thanks. =INT((TODAY()-D2)/365.25) I added the .25 for leap years "Pete_UK" wrote: Previous Posts In This Thread: On Monday, November 10, 2008 11:26 AM Gr wrote: Function to calculate the Length of Service of an Employee Hi there, I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne On Monday, November 10, 2008 11:30 AM john wrote: =DATEDIF(A1,A2,"y")Where A1= date of hire, and A2=date of reference (could be =DATEDIF(A1,A2,"y") Where A1= date of hire, and A2=date of reference (could be TODAY() for example). -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Grd" wrote: On Monday, November 10, 2008 11:30 AM Mike wrote: Function to calculate the Length of Service of an Employee Try =DATEDIF(A1,TODAY(),"y") Mike "Grd" wrote: On Monday, November 10, 2008 12:13 PM Gr wrote: Works thanks.=INT((TODAY()-D2)/365.25)I added the . Works thanks. =INT((TODAY()-D2)/365.25) I added the .25 for leap years "Pete_UK" wrote: On Wednesday, November 12, 2008 3:40 AM Pete_UK wrote: Function to calculate the Length of Service of an Employee If your hire date is in D2, try this: =3DINT((TODAY()-D2)/365) and then copy down. This does not account for leap years - is that important to you? Hope this helps. Pete a pany On Wednesday, November 12, 2008 3:40 AM Pete_UK wrote: Function to calculate the Length of Service of an Employee Okay, thanks for the feedback. Pete was a company EggHeadCafe - Software Developer Portal of Choice Insert Flash into PowerPoint 2007 http://www.eggheadcafe.com/tutorials...o-powerpo.aspx |
Calculating Years of Service
Hi,
Use the datedif() function: 1. For years =datedif(start_date,end_date,"y"), say in cell B4 2. For months =datedif(start_date,end_date,"ym"), say in cell C4 3. For days =end_date-edate(start date,(b4*12)+C4) Please note that I have not used DATEDIF(start_date,end_date,"md") to compute the days because in some cases, the answer will be a negative number -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Vivian Baker" wrote in message om... Out of all the samples I have tried the one below is the only one I could get to work. However, I am trying to calculating the years, months and days and was wondering if you have something for that? Thanks Vivian Gr wrote: Works thanks.=INT((TODAY()-D2)/365.25)I added the . 10-Nov-08 Works thanks. =INT((TODAY()-D2)/365.25) I added the .25 for leap years "Pete_UK" wrote: Previous Posts In This Thread: On Monday, November 10, 2008 11:26 AM Gr wrote: Function to calculate the Length of Service of an Employee Hi there, I have the Date Of Hire for my employees and I was wondering if there was a built in function to give the the length the employee has been in the company in whole years. Any help would be greatly appreciated. Tx Suzanne On Monday, November 10, 2008 11:30 AM john wrote: =DATEDIF(A1,A2,"y")Where A1= date of hire, and A2=date of reference (could be =DATEDIF(A1,A2,"y") Where A1= date of hire, and A2=date of reference (could be TODAY() for example). -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Grd" wrote: On Monday, November 10, 2008 11:30 AM Mike wrote: Function to calculate the Length of Service of an Employee Try =DATEDIF(A1,TODAY(),"y") Mike "Grd" wrote: On Monday, November 10, 2008 12:13 PM Gr wrote: Works thanks.=INT((TODAY()-D2)/365.25)I added the . Works thanks. =INT((TODAY()-D2)/365.25) I added the .25 for leap years "Pete_UK" wrote: On Wednesday, November 12, 2008 3:40 AM Pete_UK wrote: Function to calculate the Length of Service of an Employee If your hire date is in D2, try this: =3DINT((TODAY()-D2)/365) and then copy down. This does not account for leap years - is that important to you? Hope this helps. Pete a pany On Wednesday, November 12, 2008 3:40 AM Pete_UK wrote: Function to calculate the Length of Service of an Employee Okay, thanks for the feedback. Pete was a company EggHeadCafe - Software Developer Portal of Choice Insert Flash into PowerPoint 2007 http://www.eggheadcafe.com/tutorials...o-powerpo.aspx |
| All times are GMT +1. The time now is 06:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com