This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to calculate the date difference between two "received dates". Point A receives an item after which it delivers it to point B. I am interested in finding the date difference between these two received dates, but I am only interested in working days, i.e. I want to ignore Saturdays and Sundays. If point A receives an item on friday 2018-03-09 and point B receives that item on Tuesday 2018-03-13 the date difference in terms of working days should be 2. But, my current workflow calculates the datediff as 4 days because it counts the weekend days. Does anyone know a clever way to calculate this just for work days?
This works in a similar manner but not only can you specify holiday periods you can also select the working days specific to your business, and if you have a time field you can also specify opening hours so the clock stops 'out of hours'.