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
|