How to include weekends in the "=Diatrabalho" function and include additional holidays in Excel?

Asked

Viewed 120 times

0

I have a start date and end of a schedule, I wanted to count the weekends that in case the end date would be 11/11/2018, how to use the function:

=DIATRABALHO(C24;E24;Tabela1[DATA])

To count on the weekends?

Would it also be possible to add additional holidays? In addition to the mandatory?inserir a descrição da imagem aqui

excel

1 answer

2

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

  • I did the formula =DIATRABALHO.INTL(C24;E24;1;Table2[DATA])

  • did another update.

  • 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

  • I forgot to show where you subtract for less 1. see now

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.