Automatically Exlude Work during Weekends

#1

Looking at the formulas, I found " NetWorkingDays" very useful. Is there a way to automatically exclude Weekends days given the Start Date and End Date, without inserting them one by one? (Sorry for my english)

Thanks :slight_smile:

Exclude Weekend in the calendar/gantt chart
#2

Hi @Alberto_Eger, can you explain what you mean by “automatically exclude” weekend days? The NetWorkingDays() formula should do exactly that!

#3

@Al_Chen_Coda I’m currently struggling to use it in a specific case :
I have a formula on canvas like this : RoadmapTable.DateEnd.Nth(5)-Today()
This formula should give me the last milestone end date and with the subtraction give me the number of days remaining. But I never found a way to use will the Networking days formula to give me only the working days remaining.
Do you have an advice for me? Thanks!

#4

I set up a table to give this a try, and it works, but it could be that you have a more complicated table or formula. If you can post more or a screenshot of the table, we can dig further.

For now, here’s what I set up and how I used the formulas:

CloudApp

[Days Remaining]
Type: Duration
Formula: DateEnd-Today()

[Working Days Remaining]
Type: Duration
Formula: NetWorkingDays(Today(),DateEnd)

2 Likes
#5

@benblee Thanks great explanation. :bulb:
Quite important to add “bank holidays” in the NetWorkingDays :calendar: formula to get the correct result.

Kind regards,
@Jean_Pierre_Traets

#6

Thanks @benblee it works like a charm!

1 Like
#7

Thank you!

@Jean_Pierre_Traets, I added Holidays now using a second table so they can be listed for the year.

Holidays Table

https://cl.ly/943f8c

Days Remaining Table

https://cl.ly/2ef331

[Days Remaining]
Type: Duration
Formula: DateEnd-Today()

[Working Days Remaining]
Type: Duration
Formula: NetWorkingDays(Today(),DateEnd,Holidays.Date)

3 Likes