Remove weekends from date fields

[Pinky]

Hi Team,

I have data like shown below. I have two date fields which date1 and date 2 and date difference field is date2 -date1 and it is in seconds. So what i want is i have to remove the weekends(Sat, Sun) when i subtract the date2 from date1 field. like for example

1/27/2021 16:26

2/1/2021 11:05

412714

here the difference the dates are from 1/27 to 2/1. So i want to remove the weekends which is 1/30 and 1/31 which Sat &Sun when i subtract date2 and date1. Can any one help me on this issue? I appreciate your help in advance. Thanks!

Date1	Date2	Date Difference in Seconds
3/18/2020 2:17	3/20/2020 14:43	217565
9/3/2020 14:51	9/14/2020 14:17	948395
8/31/2020 16:42	8/31/2020 16:42	34
10/15/2020 14:43	10/20/2020 20:06	451411
10/22/2020 17:00	10/23/2020 11:28	66536
9/25/2020 16:06	9/29/2020 19:15	356941
9/29/2020 19:55	10/9/2020 19:18	861795
10/1/2020 15:51	10/1/2020 16:08	1065
10/1/2020 21:14	10/13/2020 21:57	1039357
10/2/2020 15:26	10/14/2020 15:42	1037755
10/2/2020 15:44	10/14/2020 15:53	1037331
10/2/2020 16:34	10/2/2020 16:40	331
10/5/2020 14:13	10/15/2020 4:23	828620
10/5/2020 14:34	10/15/2020 4:26	827526
10/5/2020 16:55	10/15/2020 18:49	870855
10/5/2020 17:45	10/15/2020 19:07	868897
10/5/2020 18:22	10/15/2020 20:41	872345
1/27/2021 16:26	2/1/2021 11:05	412714

[clmc9601]

Hi @Pinky,

I built a workflow that will identify weekends and calculate the total number of seconds. You can add this workflow onto your previous workflow which calculates the difference in seconds. I hope it helps! 

[Pinky]

This works as expected. Thanks for your reply.

[clmc9601]

Hi @Pinky, if my above post resolved your question, could you please mark it as a solution? Having this post marked as solved improves the community search engine for others seeking solutions, and I would greatly appreciate it. Thanks! 

If it didn't resolve your question, I'm happy to keep working with you to find a solution!