Networkday with Holiday

[stapuff]

A18 = 3 (represent the month number)
A19 = 1 (represent # of days to remove due to holiday)

Year = current year

C19 I have this formula
=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(A18),DAY(1)),DATE(YEAR(TODAY()),MONTH(A18),EOMONTH(A18,0)))-A19

End result is 20 when it should be 22

Any thought to calculate networkdays in any given month?

Thanks,

Stapuff

 

[barry houdini]

Try this version

=NETWORKDAYS(DATE(YEAR(TODAY()),A18,1),DATE(YEAR(TODAY()),A18+1,0))-A19

 

[stapuff]

Outstanding piece Barry. I appreciate the help.

Stapuff