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

Maybe...

=IF(DATEDIF(B16,TODAY(),"Y")11,20,
INT(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0))&" days "&
8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0),1) & " hours")

(You didn't need those ()'s around the whole formula.





Richard wrote:

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

--

Dave Peterson