Forum Discussion

FrogFace's avatar
FrogFace
Copper Contributor
Dec 14, 2023

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 ta...
Formulas and Functions
FrogFace's avatar
FrogFace
Copper Contributor
Dec 14, 2023
I would like to add, e12:ab47 should auto populate "X" after entering the estimated start date and duration.
Thanks
  • FrogFace's avatar
    FrogFace
    Copper Contributor
    Dec 14, 2023
    looks 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
    • FrogFace's avatar
      FrogFace
      Copper Contributor
      Dec 14, 2023
      Disregard previous message. All good thank you Hans Vogelaar for your help.

Resources