Tweaking formula?
B16 is the Actual Hire Date
"Franz Verga" wrote:
Richard wrote:
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")
Hi Richard,
and what about cell B16?
--
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|