Count the number of leave days from start and End date and Exclude the weekend day.

[iahmadmca1]

Hi Team,

I have shared the dummy data based on that I need to calculate the leave day from start date and end date and exclude the weekend day.

Start date	End date	Name	date
1/1/2019	1/5/2019	A	1/1/2019
1/2/2019	1/5/2019	b	1/2/2019
1/3/2019	1/6/2019	c	1/3/2019
1/4/2019	1/7/2019	d	1/4/2019
1/5/2019	1/8/2019	e	1/5/2019
1/6/2019	1/9/2019	f	1/6/2019
1/7/2019	1/9/2019	g	1/7/2019
1/8/2019	1/11/2019	h	1/8/2019
1/10/2019	1/13/2019	i	1/9/2019
1/11/2019	1/15/2019	j	1/10/2019
1/13/2019	1/15/2019	k	1/11/2019
1/14/2019	1/17/2019	l	1/12/2019
1/15/2019	1/17/2019	m	1/13/2019
1/16/2019	1/18/2019	n	1/14/2019
1/17/2019	1/20/2019	o	1/15/2019

Thanks in advanced.

Thanks,

Regards,

[sunny_talwar · Accepted solution]

May be this

NetWorkDays([Start date], [End date])

[iahmadmca1]

Thank you sunny for you quick response. I got the expected output.

[sunny_talwar]

What did you use?

[iahmadmca1]

I used same which you have replied.

Thanks,

Irshad Ahmad

[sunny_talwar]

Oh okay, cool. You marked your own response as correct which confused me. Thanks for the clarification