I have this formula in cell B17 =DATEDIF(B16,TODAY(),"Y")&" years,
"&DATEDIF(B16,TODAY(),"YM")&" months "&DATEDIF(B16,TODAY(),"MD")&" days" This
gives me the total years of employment. I need to take that info and match it
with column "I" then whatever is in column "J" send that to "A3"
Crude Example: If B17 = whats in column "I5" then send whats in column "J5"
to "A3"
B17 shows the years, months and days but column "I" only shows whole numbers
like 1,2,3,4, etc...can they still match for example: B17 = 7 years, 2 months
5 days, I need that to match with 7 years in column "I"
Thanks in Advance!! Tough one for me!