Date subtraction considering weekends

Hello everyone, below is my requirement,

I want to subtract two dates considering weekends. It should be like this,

22nd March 2019(Friday) - 21 March 2019(Thursday) should give result as 1.
However 25th March 2019(Monday) - 22nd March 2019(Friday) should also give result as 1 as there are weekends in between.

Any help on it would be much appreciated.


Please find the attached workflow. If you have any doubts then let me know.

Date.xaml (19.0 KB)

Thanks Lakshman!! I owe to you!!:slightly_smiling_face:

1 Like


If it works for you then please close this thread and mark it as solution. It helps others too.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.