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.
Solved! Go to Solution.
The Date list needs to be comma separated. It's only picking up the first Holiday date in the list.
I hope this helps!
The Date list needs to be comma separated. It's only picking up the first Holiday date in the list.
I hope this helps!
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |