Cell "L1" is used only for the first year which is prorated, "After" the
first year I need it to show a 10 in cell "L1"
This is what I have now in cell "L1"
=IF(TODAY()-B16<90,0,INT((DATE(YEAR(B16),12,31)-B16)*0.0274)+0.5)
This is what I have in cell "A3"
=IF(DATEDIF(B16,TODAY(),"Y")11,20,INT(VLOOKUP(DAT EDIF(B16,TODAY(),"Y"),K:L,2,0))&" Days "&8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0), 1)& " hours")