Forum Discussion
FrogFace
Dec 14, 2023Copper Contributor
Scheduling visual with start dates & durations to exclude weekends.
I have this simple spreadsheet which a14 to a47 is a list of tasks. $B$14 is the task start date, C14 is the duration of the task, and e12:ab12 are dates from Monday 11/13 to Saturday 12/9. If the task start date and duration is >= e12:ab12, then return "X" in e14:ab47. I want to show an "X" as a visual to the task's start date and duration in range e14:ab47. We don't work weekends, so these days should not have an "X" and not be counted in the duration of the task. any assistance would be appreciated.
Activity | Est. | Act. | Responsible | |||||||||||||||||||||||||
Description | Start | Duration | Start | Month: | Month: | Month: | Party | |||||||||||||||||||||
13 | 14 | 15 | 16 | 17 | 18 | 20 | 21 | 22 | 23 | 24 | 25 | 27 | 28 | 29 | 30 | 1 | 2 | 4 | 5 | 6 | 7 | 8 | 9 | |||||
M | T | W | T | F | S | M | T | W | T | F | S | M | T | W | T | F | S | M | T | W | T | F | S | |||||
Exterior Tracks | 11/13 | 7 | 13-Nov | X | X | X | X | X | X | Carpenters |
4 Replies
Sort By
- FrogFaceCopper ContributorI would like to add, e12:ab47 should auto populate "X" after entering the estimated start date and duration.
Thanks- FrogFaceCopper Contributorlooks good thank you for your help. I would like to take out the "S" indicating Saturdays but this format is from my office and I don't want to change it. Is there a way to keep Saturdays visualized in the chart ? that was my main problem.
Thanks