Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Workday not working properly

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 Solved
0 1 110
1 ACCEPTED 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!

View solution in original post

1 REPLY 1

The Date list needs to be comma separated.   It's only picking up the first Holiday date in the list.

I hope this helps!

Top Labels in this Space