Date subtraction considering weekends

Help
1

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.

2

@Kapil,

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

Date.xaml (19.0 KB)

3

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

1 Like
4

@Kapil,

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

5

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