- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 31, 2023 08:53 AM
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?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 31, 2023 10:35 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 31, 2023 10:35 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 01, 2023 10:19 AM
Thanks! I think that basically solves it for me!
