Remaining workdays

  • Thread starter Thread starter Don Rountree
  • Start date Start date
D

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
 
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)
 
=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.
 
This is a very useful formula, but how can you have it take out the
weekend days (Sat & Sun)?
 
--

HTH

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks, I tried using NETWORKDAYS.....if there a VB script one would
have to write in....??

=NETWORKDAYS(YEAR(TODAY()),MONTH(TODAY())+1,0)-TODAY()
 
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)
 
Is there something I need to add in to get the "NETWORKDAYS" to work? I
tried this and it give "#NAME?"
 
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)
 
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)
 
Back
Top