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 function showing weekends
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')
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

