0
You can use the function:
=DIATRABALHO.INTL(data inicial; dias;[fimdesemana], [feriados])
On weekends, you can inform what you consider this weekend. Whether it is Saturday or Sunday (1) or other options.
Excel, in newer versions, will show the options you can inforar in [fimdesemana]. Use the same formula, but using the endpoint.
=DIATRABALHO.INTL(C24;E24;1;Tabela1[DATA])
Note the number 1 in the above function.
However, in your case, you can ignore the options you have there and use it like this:
=DIATRABALHO.INTL(C24;E24;"0000000";Tabela1[DATA])
If the answer is giving an extra day, do this: subtract -1.
=DIATRABALHO.INTL(C24;E24;"0000000";Tabela1[DATA])-1
He still hit until the 16th, I do not know why, was to go until the 11th
– Elienay Junior
I did the formula =DIATRABALHO.INTL(C24;E24;1;Table2[DATA])
– Elienay Junior
did another update.
– Rodrigo Rocha
It didn’t fall on day 11, it fell on day 12, I tried to subtract by putting 6 zeros and even then it wasn’t, I tried by -1 in different places, but from error
– Elienay Junior
I forgot to show where you subtract for less 1. see now
– Rodrigo Rocha