View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga
 
Posts: n/a
Default how long date difference

Nel post
*hellZg8* ha scritto:

I'm looking for a way to find out how long an employee has been with
the company.

I enter the start date in one column and in the next column it has
today's date
then in the third column it has the difference between the two.

thanks in advance


A2 = start date
B2 = TODAY()

C2=B2-A2

this way work fine if the dates are real dates, not inputed as text; if this
is the case, you can use:

C2=VALUE(B2)-VALUE(A2)

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy