Try this:

A1 = hire date

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

--
Biff
Microsoft Excel MVP


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