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 "
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 "