Forum Discussion

kumar25's avatar
kumar25
New Contributor II
2 years ago

Difference between 2 dates, excluding weekends

I have 2 date values, have to find the difference between both of them. Weekends to be excluded. I am using the below expression to derive the value. parseInt((Date.parse($Date2.toString())-Date.pa...
Aleksandar_A's avatar
Aleksandar_A
Contributor III
2 years ago

Hello kumar25.

Attached below is a sample pipeline that you can use.

 

In general, as a short explanation, I was following the steps below:

  1. Calculate Days Diff between the Start and End Date.
  2. Generate all days in that interval.
  3. Filter out the weekends.
  4. Count the remaining days.

Let me know if you have any questions and if this helps you.

Regards,

Aleksandar.