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
could have a "years of service" column
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
is there a formula that will subtract todays date from a hire date
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
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
T
T. Valko
Try this:
A1 = hire date
=DATEDIF(A1,NOW(),"y")
A1 = hire date
=DATEDIF(A1,NOW(),"y")
J
Jacob Skaria
With hire date in A1 try
=DATEDIF(A1,TODAY(),"y")
If this post helps click Yes
=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")
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")