Exclude weekends from formula column: Day Count

Has anyone found a way to exclude weekend day counts in a “day count” formula column?

I’m using this to subtract due date columnt from start date column but I don’t want it to count weekend days. I just want actual working/business days.
DAYS({Due date}, {Start date})

Thank you!

1 Like

Hey Amy,

Ben here, happy to help!

Here is the formula that I would use

ROUND(DAYS({Due date},{Start date})-(2*(WEEKNUM({Due date})-WEEKNUM({Start date}))),1)

The Weeknum function will find the week number of the year - so for example, if we are discussing
December 1st, that is the 48th week. If the start date was November 1st, that would be the 44th week. I then minused the 2, ( which results in 4) meaning that I now have the number of weeks between the 2 days, and then multiplied it by 2, as there are 2 weekend days a week.

Hope this helps:)

3 Likes

Ben,

Thank you! This works perfectly. I really appreciate you taking the time to work this out for me!!

Best,
Amy

Hi Ben,

Is it still possible to do this ? I would like to do exactly the same shit.

Thanks,

Maxime

Works fine thanks! has anyone tried to do the same with timeline bar and succeeded?

Hey @maximepmdc - did the formula Ben added not work for you or are you looking for a different one?

Hey @yossi.shamir - at this time the Timeline column is not supported in the Formula column but we are looking to add it later this year.

Let us know if there is anything else we can help you with.

1 Like

With the new “Workload” dashboard widget, it is very helpful to have a timeline column. The problem with timeline columns is they don’t work with formulas, as expressed in this post. Please work quickly to add this functionality.