count number of workdays exluding holidays in 2016 between 09/01/2015 and 09/15/2017

[mdwgno]

I need to count the number of workdays exluding a list of holidays in 2016 between 09/01/2015 and 09/15/2017

 

[Dave Patton]

check information on

NETWORKDAYS function


Description

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays.

 

[mdwgno]

check information on

NETWORKDAYS function


Description

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays.

I am using the formula NETWORKDAYS.INTL(A2,B2,7,Holidays!A:A),0)
(where HOLIDAYS is a separate tab in the workbook listing the days of holidays to exclude.

I need to modify the formula where the results are for the year 2016 only.

 

[Nine Zero]

could you set A2 to 01/01/2016? just for this case

 

[Dave Patton]

Excel 2010
	A	B	C
2	1-Jan-16	31-Dec-16	260
6c

Cell Formulas
Range	Formula
C2	=NETWORKDAYS.INTL(A2,B2,7,Holidays)

Named Ranges
Name	Refers To	Cells
Holidays	='6c'!$I$5

The Holidays is a name range that has the dates of holidays for your country.
Your answer will be different since I do not know the range that includes your holidays.
Ignore the sheet name cited above; it is applicable only for my example.

N.B. I used your code 7 for the formula and I deleted the 0 at the end of the formula.