Calculate Number of years

[Needs Help]

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!

 

[JE McGimpsey]

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.

 

[Pete_UK]

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

 

[Peo Sjoblom]

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

 

[Bob Phillips]

=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)