is there a formula that will subtract todays date from a hire date
 

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

Answer: is there a formula that will subtract todays date from a hire date
 

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".

is there a formula that will subtract todays date from a hire date
 

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

is there a formula that will subtract todays date from a hire date
 

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

is there a formula that will subtract todays date from a hire date
 

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

is there a formula that will subtract todays date from a hire date
 

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