Help

Workday function showing weekends

Topic Labels: Formulas
631 2
cancel
Showing results for 
Search instead for 
Did you mean: 
SilverTran
4 - Data Explorer
4 - Data Explorer

I am trying to have a due date automatically calculated, but don't want weekends or holidays included. I am using the WORKDAY function, but still getting weekends. Workback from is the date to begin working on each task and Workback is the number of days allowed for each task. Can someone help?

Here is what I am using: 

WORKDAY({Workback from}, {Workback},'2023-10-23,2023-11-23, 2023-11-24, 2023-12-22, 2023-12-25, 2023-12-26, 2023-12-27, 2023-12-28, 2023-12-29,2024-01-01, 2024-01-15, 2024-02-09, 2024-02-19, 2024-03-29, 2024-05-06, 2024-05-27, 2024-07-01, 2024-07-02, 2024-07-03, 2024-07-04, 2024-07-05, 2024-09-02, 2024-09-20, 2024-10-25, 2024-11-28, 2024-11-29, 2024-12-24, 2024-12-25, 2024-12-26, 2024-12-27, 2024-12-28, 2024-12-29, 2024-12-30, 2024-12-31, 2025-01-01')
2 Replies 2

Could you provide a screenshot of this error happening? 

Hi,
I tried your formula, and it works as expected. Please share your use case

Alexey_Gusev_0-1714094552517.png