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