Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
May be this
NetWorkDays([Start date], [End date])
Thank you sunny for you quick response. I got the expected output.
What did you use?
I used same which you have replied.
Thanks,
Irshad Ahmad
Oh okay, cool. You marked your own response as correct which confused me. Thanks for the clarification