Hi,
in one cell enter the formula as follow

=today()
this will bring todays date, let's say is in cell E5, then use the formula
as follow to calculate the difference

=DATEDIF(D5,$E$5,"y")&" years "&DATEDIF(D5,$E$5,"ym")&" months
"&DATEDIF(D5,$E$5,"md")&" days"

Change range to fit your needs

if this help please click yes, thanks

"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