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

1. In a new column, enter the hire date for each employee.
2. In the next column, enter the following formula: =DATEDIF(B2,TODAY(),"y")&" years"
3. Replace "B2" with the cell reference of the hire date for the first employee.
4. The formula will calculate the number of years between the hire date and today's date, and display the result with the word "years" added at the end.
5. Copy the formula down to the rest of the rows to calculate the years of service for each employee.

Note: The DATEDIF function calculates the difference between two dates in years, months, or days. The "y" argument in the formula tells the function to calculate the difference in years. The "&" symbol is used to concatenate the result with the word "years".

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

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

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

With hire date in A1 try

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

If this post helps click Yes
---------------
Jacob Skaria


"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