Help

Return a date using a start date and forecast number of workdays but count only workdays

Topic Labels: Formulas
Solved
Jump to Solution
489 2
cancel
Showing results for 
Search instead for 
Did you mean: 
BryceD
5 - Automation Enthusiast
5 - Automation Enthusiast

I have two fields

  • a start day for a task (date field)
  • an estimated number of workdays the work will take to complete (a number).

I want to add those workdays to the start date and count ahead to the date the work will be completed. I do not want to count weekends.

I've tried the formula below to estimate the date the task will be completed by combining my two fields.

 

DATEADD({Imaging Start Date},{Forecast Workdays for this Batch},'days')

 

However, that counts weekend days as workdays, thus returning an earlier forecasted completion date.

For example, if the work starts 6/1/23 and should take 10 workdays, the returned date should be 6/14/23, not 6/10/23.

Is there a way to account for this in my formula or the data?

 

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

Could you try using `WORKDAY()` instead?  Link to documentation

Screenshot 2023-06-01 at 1.34.36 PM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

Could you try using `WORKDAY()` instead?  Link to documentation

Screenshot 2023-06-01 at 1.34.36 PM.png

BryceD
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks! I think that basically solves it for me!