AGE or TENURE

TABLE 1:

Name

Abc

Date of Joining

01/01/08

Tenure

TABLE 2:

=DATEDIF(B2,TODAY(),"y")&" Yr, "&DATEDIF(B2,TODAY(),"ym")&" Mth, "&DATEDIF(B2,TODAY(),"D")&" Dy "