workdays formula

[kumar1803]

Hello,

I need help with counting days from current days using workdays formula where I need to exclude all weekend and holidays.

My start date 12/07/2015

I need the number of days to current excluding holidays and weekend. there are 5 days in work days.

here is the holiday list:

[TABLE="width: 183"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]2016[/TD]
[TD="align: right"]1/1/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1/18/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2/15/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5/30/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]7/4/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]9/5/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]10/10/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]11/11/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]11/24/2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]12/25/2016[/TD]
[/TR]
[TR]
[TD="align: right"]2017[/TD]
[TD="align: right"]1/1/2017[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Are you trying to get the number of working days between 12-Jul-2015 and today's date?

 

[myexcelcraze]

Use the function WORKDAY()