Exclude Weekend in the calendar/gantt chart

That’s the problem, I tried to create a gantt chart using START and DURATION columns.

I expected to see how the time would be distributed from the starting date to the date that will be calculated based on the duration of the work.

The problem was that it is impossible to exclude weekends when applied to real dates.

I couldn’t do it in the calendar either.
The schedule is built without taking into account that no one will work on Saturday and Sunday.

Maybe I was looking bad in the FAQ.
I was able to find this topic - Automatically Exlude Work during Weekends
But I did not understand how I can apply to my problem.

I would be grateful for the help.

Hello @santonia_santy,

This is available with coda’s default “Workday” calculation

[Start] is entered by you
[Working Days] is entered by you
[End] is calculated by =Workday(Start,[Working Days]) and you can add in a list of holidays if you wish
[Real Duration] is calculated by =End-Start

Producing the below, hope that helps!
Thanks, Bobby

image