Duration Including Weekends

danielle.clements

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

Ray Lindstrom

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