This formula is what I'm using to lookup vacation days in A3 which has a half
day(4 hours). I'd like for it to read whatever is in Column L such as 4.5
(something like "4 days 4 hours")
=(IF(DATEDIF(B16,TODAY(),"Y")11,20,VLOOKUP(DATEDI F(B16,TODAY(),"Y"),K:L,2,0)))