Calculo de dias úteis

Preciso calcular X dias a partir da data atual, porém contando apenas dias úteis. Alguém tem alguma sugestão?

Exemplo:
Data inicial: 04/11/22
Inpute Dias: 137 dias
Data final (contando apenas dias úteis): ?

It would be a VERY rough number but you could enable the experimental parenthesis feature, then multiply your days by (5/7) then after all of that do :ceiling so it rounds up to the next whole day. It wouldn’t exclude holidays of course but it could get you an close estimate of the weekdays

1 Like

Eu não sabia sobre esse recurso do parenteses :woozy_face: então fiz exatamente isso usando um input para a expressão.

Muito obrigado.

In the Settings menu, under Versions tab, you can enable parenthesis to allow for correct order of operations

20 days * 5/7 = 14.285:ceiling = 15 days (correct)
3 days * 5/7 = 2.143:ceiling = 3 days (correct)
137 days * 5/7 = 97.851:ceiling = 98 days (according to Business Days Calculator – Count Workdays it would be 97 days assuming 1/1/22 to 5/17/22 so it varies date/per date clearly)