Excluding Weekends from Date formulas?


I'm hoping this is possible and someone can guide me, but I am trying to automatically exclude weekends from date formulas.

In my sheet I have a duration column (which is calculated based on a number of other columns: task performed, difficulty level of task, etc) and then a start/end date column which calculates on how long the duration will be. Note, the duration column is simply titled duration, it is not a "duration" column type.

However, when dates expand over the weekends I would want them excluded seeing is this is finding start/end work days.

Thanks, any help is appreciated!


Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    Okay, I think I get what you are saying now. These two formulas would replace the ones in your screenshots.

    =IFERROR(WORKDAY([Start Date]11, -CEILING([Delay (Days)]@row + [Duration (Days)]@row, 1)), "")

    =IFERROR(WORKDAY([Start Date]@row, CEILING([Delay (Days)]@row + [Duration (Days)]@row, 1)), "")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!