Calculate Number of years
 

I am trying to calcualte number of years an employee has been with the
company from today's date. I can't seem to find a formula that will help me
with that.

Also, I need a formula that will calculate 75 workdays from date of hire.

Thanks!

Calculate Number of years
 

One way:

Number of years:

A1: <start date
B1: =DATEDIF(A1,TODAY(),"y")

See http://cpearson.com/excel/datedif.htm for more on DATEDIF()


75 Workdays:

=WORKDAY(A1,75)

Requires the Analysis Toolpak Add-in for pre-XL07/08. See XL Help for
details.


In article ,
Needs Help wrote:

I am trying to calcualte number of years an employee has been with the
company from today's date. I can't seem to find a formula that will help me
with that.

Also, I need a formula that will calculate 75 workdays from date of hire.

Thanks!

Calculate Number of years
 

If you have a hire date in A1, then this formula in B1 will give you
the number of years:

=(TODAY()-A1)/365.25

Format the cell as General, or as Number with 2 dp.

To get 75 days after a hire date which is in A2, use this:

=A2+75

Format this cell as a date.

Hope this helps.

Pete

On Dec 7, 3:02 pm, Needs Help
wrote:
I am trying to calcualte number of years an employee has been with the
company from today's date. I can't seem to find a formula that will help me
with that.

Also, I need a formula that will calculate 75 workdays from date of hire.

Thanks!

Calculate Number of years
 

If you only want the calendar days just use

=TODAY()-start

e.g.

a1 holds the start date 08/12/1995

=TODAY()-A1


format as general will return the days, if you want years look here

http://www.cpearson.com/excel/datedif.aspx

will look like

=DATEDIF(A1,TODAY(),"y")



--


Regards,


Peo Sjoblom


"Needs Help" wrote in message
...
I am trying to calcualte number of years an employee has been with the
company from today's date. I can't seem to find a formula that will help
me
with that.

Also, I need a formula that will calculate 75 workdays from date of hire.

Thanks!

Calculate Number of years
 

=DATEDIF(Start_date,TODAY(),"Y")

=WORKDAY(DoH,75)

if you define a set of holiday dates in a range, you can also include that

=WORKDAY(DoH,75,holidays)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Needs Help" wrote in message
...
I am trying to calcualte number of years an employee has been with the
company from today's date. I can't seem to find a formula that will help
me
with that.

Also, I need a formula that will calculate 75 workdays from date of hire.

Thanks!