Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Workday function showing weekends

Topic Labels: Formulas
790 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