Tweaking formula?

[Richard]

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(DATEDIF(B16,TODAY(),"Y"),K:L,2,0))&" Days "&8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0),1)& " hours")

 

[Franz Verga]

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(DATEDIF(B16,TODAY(),"Y"),K:L,2,0))&"
Days "&8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0),1)& " hours")

Hi Richard,

and what about cell B16?

--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Richard]

B16 is the Actual Hire Date

Hi Richard,

and what about cell B16?

--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy