Duration Including Weekends

Options

Hello!

We have our project (task tracker) set to exclude weekends, which is what we need as we don't want anything due on the weekend. However, we need a duration column that includes all days between the start and end date, not just the business days. How can I do this? It's currently showing the duration of business days only which will confuse our consultants.

Thanks!

Danielle

Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 10/17/23
    Options

    Hi @danielle.clements,

    I have 2 sets of date columns: Target Start Date, Target End Date, Actual Start Date, and Actual End Date.

    You could create a column, and call it whatever you want (such as Duration With Weekends).

    Then paste subtract the dates like this using a column formula: =[Actual End Date]@row - [Actual Start Date]@row

    Replace my column names with that of your own. Both columns should be Date type, or else this won't work.

    BRgds,

    -Ray

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!