Remaining workdays

[Don Rountree]

I would like to write a formula that gives me the
remaining work days in the month, excluding holidays, and
not counting the current days. Work days are all days
between Monday through Friday. When I think about it, my
hair hurts. Any help would be appreciated.

Don Rountree

 

[Gerry Kuta]

http://www.cpearson.com/excel/holidays.htm and
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-TODAY()
Might help you get there!
HTH

 

[Jonathan Cooper]

=NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0))

 

[Bob Phillips]

Don,

=NETWORKDAYS(TODAY(),DATE(YEAR(TODAY()),MONTH(TODAY())+1,0),holidays)-1

where holidays is a named range list of holidays. NETWORKDAYS is part of the
Analysis Toolpak, so make sure that is installed.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jonathan Cooper]

=NETWORKDAYS(TODAY()+1,EOMONTH(TODAY(),0)).

You'll have to manually subtract the number of holidays
off the end of the formula. You can also create a list
of holidays, and add that into the networkdays formula to
get it to subtract for you.

 

[gacollege]

This is a very useful formula, but how can you have it take out the
weekend days (Sat & Sun)?

 

[Bob Phillips]

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

NETWORKDAYS does that automatically.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[gacollege]

Thanks, I tried using NETWORKDAYS.....if there a VB script one would
have to write in....??

=NETWORKDAYS(YEAR(TODAY()),MONTH(TODAY())+1,0)-TODAY()

 

[Bob Phillips]

You don't subtract 1 date from the other, you pass them both to the function

=NETWORKDAYS(TODAY(),DATE(YEAR(TODAY()),MONTH(TODAY())+1,0),holidays)-1


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[gacollege]

Is there something I need to add in to get the "NETWORKDAYS" to work? I
tried this and it give "#NAME?"

 

[Bob Phillips]

Yes, go to Tools>Addins and check the Analysis Toolpak item.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Chip Pearson]

You need to load the Analysis Tool Pak add-in in order to use the
NETWORKDAYS function. Go to the Tools menu, choose Add-Ins and put a check
next to "Analysis ToolPak".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)