Hi,
Need help with this formula to show every three letters Ex. Day 1 aaa day 2 bbb day 3 ccc .....
Like it is, it shows Day 1 aaa day 2 aab day 3 abb day 4 bbb etc.....
=IF(OR(I$12="";I$12<$R$5;$B14="");"";IF(NETWORKDAYS.INTL(I$12;I$12;weekend;holidays)=0;"nw";IFERROR(INDEX(daysoff_type;MATCH(I$12&" "&$B14;daysoff_lookup;0));MID($C14;MOD(NETWORKDAYS.INTL($R$5;I$12;weekend;holidays)-1;LEN($C14))+1;3))))
Need help with this formula to show every three letters Ex. Day 1 aaa day 2 bbb day 3 ccc .....
Like it is, it shows Day 1 aaa day 2 aab day 3 abb day 4 bbb etc.....
=IF(OR(I$12="";I$12<$R$5;$B14="");"";IF(NETWORKDAYS.INTL(I$12;I$12;weekend;holidays)=0;"nw";IFERROR(INDEX(daysoff_type;MATCH(I$12&" "&$B14;daysoff_lookup;0));MID($C14;MOD(NETWORKDAYS.INTL($R$5;I$12;weekend;holidays)-1;LEN($C14))+1;3))))