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

=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

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

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

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

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 -

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

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

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