I need to calculate the deadline date of a project, based on the date tha the project was started.
The deadline must be calculated in workdays (exluding weekends and holidays in my region), so I used the formula WORKDAY(), but it’s not calculating the dates I wrote on the formula, that follows:
WORKDAY([Data Solicitacao], [Prazo], LIST(“03/03/2025” “04/03/2025” “05/03/2025” “19/03/2025” “24/03/2025” “25/03/2025” “18/04/2025” “21/04/2025” “01/05/2025” “19/06/2025” “22/07/2025” “07/09/2025” “15/09/2025” “12/10/2025” “28/10/2025” “02/11/2025” “15/11/2025” “20/11/2025” “24/12/2025” “25/12/2025” “31/12/2025”))
“Data Solicitacao” is the inicial date;
“Prazo” is the amount of days that the project requires.