Thread: is there a formula that will subtract todays date from a hire date
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
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 With QuoteReply With Quote