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

H

Heather

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

Eduardo

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
 
J

Jacob Skaria

With hire date in A1 try

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

If this post helps click Yes
 
S

Shane Devenshire

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workday Formula to include date 0
Date formula 3
Copying formulas 1
Function to Return a Date Value Q 4
formula help: calculate length of employment 2
How do I subtract todays date from range of dates 1
(YEARS) Excel Formula 2
I want a formula to find age of person 2

Top