NETWORKDAYS function

[ProjectGuy]

I am using this formula to show current networkday in each month, with out weekends and holidays minus one day.=IF(ISNUMBER(B6),NETWORKDAYS(C6,TODAY(),$H$3:$H$12),"Closed")-1 How do you make the formula quit counting at end of month? previous month cells are continuing to count past end of month. Also, future months show negative days which should show.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(ISNUMBER(B6),NETWORKDAYS(B6,C6,$H$3:$H$12),"Closed")-1

 

[ProjectGuy]

Thanak you Fluff,
That works for previous months, but may shows total days. I need it to show the current day which is 4. now showing 19.

 

[Fluff]

Ok, how about

=IF(ISNUMBER(B6),NETWORKDAYS(B6,IF(MONTH(C6)=MONTH(TODAY()),TODAY(),C6),$H$3:$H$12),"Closed")-1

 

[ProjectGuy]

Fluff you are Awesome!!
One more question. Is there away to have the forthcoming months to show zero until the calendar rolls to them?

 

[Fluff]

How about

=IF(B6<>"",IF(MONTH(B6)>MONTH(TODAY()),0,NETWORKDAYS(B6,IF(MONTH(C6)=MONTH(TODAY()),TODAY(),C6),$H$3:$H$12)-1),"Closed")

 

[ProjectGuy]

That is perfect! thank you so much I really appreciate you helping me with this issue.

Just curious how would you invert the formula to count down?

 

[Fluff]

That is perfect! thank you so much

You're welcome & thanks for the feedback.