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 
Hi @Alberto_Eger, can you explain what you mean by “automatically exclude” weekend days? The NetWorkingDays() formula should do exactly that!
@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!
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:
[Days Remaining]
Type: Duration
Formula: DateEnd-Today()
[Working Days Remaining]
Type: Duration
Formula: NetWorkingDays(Today(),DateEnd)
2 Likes
@benblee Thanks great explanation. 
Quite important to add “bank holidays” in the NetWorkingDays 
formula to get the correct result.
Kind regards,
@Jean_Pierre_Traets
Thanks @benblee it works like a charm!
1 Like
Thank you!
@Jean_Pierre_Traets, I added Holidays now using a second table so they can be listed for the year.
Holidays Table
Days Remaining Table
[Days Remaining]
Type: Duration
Formula: DateEnd-Today()
[Working Days Remaining]
Type: Duration
Formula: NetWorkingDays(Today(),DateEnd,Holidays.Date)
3 Likes