Solved

Totaling current count of workdays in the month

Posted on 2008-06-24
4
634 Views
Last Modified: 2010-04-21
Does anyone know what excel function or combination of functions to use to count the current number of workdays in a month?

i.e. June = 21 use networkday function

how do I count the total # of workdays so far this month?
6/24 = workday 16 out of 21

i am using office 2007

Thanks!

I am trying to setup a ratio of the count of current days over the count of total days
0
Comment
Question by:kpwhitte
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 21861501
today's networkdays in the month:
=networkdays(DATE(YEAR(NOW()),MONTH(NOW()),1),NOW())
total networkdays in the month
=networkdays(DATE(YEAR(NOW()),MONTH(NOW()),1),DATE(YEAR(NOW()),MONTH(NOW())+1,1)-1)
0
 

Author Closing Comment

by:kpwhitte
ID: 31470413
Works perfectly - mucho thanks for the help.
0
 

Author Comment

by:kpwhitte
ID: 21865143
thanks
0
 
LVL 45

Expert Comment

by:patrickab
ID: 21865491
kpwhitte,

Or you could use:

=NETWORKDAYS(EOMONTH(TODAY(),-1)+1,EOMONTH(TODAY(),0),E2:E6)

where E2:E6 contains the list of dates which are public holidays. That formula will update automatically for whatever month it is - provided the list of public holidays in that month is correct.

I think you'll need the Analysis ToolPak installed for EOMONTH to work. Tools/Add-ins and tick the Analysis ToolPak option, press OK.

Patrick
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question