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!