Hi,

The formula will depend on what you define as years of service.

If it's just whole years then

In A1 enter the Date of Hire as a date
In A2 enter =DATEDIF(A1,TODAY(),"y")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Heather" wrote:

is there a formula that will subtract todays date from a hire date so that I
could have a "years of service" column