Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 148
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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".
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtract one year from todays date Nigel Excel Discussion (Misc queries) 6 May 1st 08 06:06 PM
Figuring Vacation Hrs. Earned using Current Date minus Hire Date Sharon Excel Worksheet Functions 6 May 3rd 07 10:32 PM
formula for lenght of employment based on hire date Mharper Excel Worksheet Functions 1 March 27th 06 09:51 PM
Formula to subtract a date from current date Fidelio1st Excel Worksheet Functions 3 February 27th 06 04:36 AM
todays date formula BigAl1322 Excel Worksheet Functions 3 October 24th 05 11:17 AM


All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"