Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Totaling current count of workdays in the month

Posted on 2008-06-24
Medium Priority
648 Views
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
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
• 2

LVL 39

Accepted Solution

nutsch earned 2000 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

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

Author Comment

ID: 21865143
thanks
0

LVL 45

Expert Comment

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

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month9 days, 15 hours left to enroll