Generating business days in a calendar month, EXCLUDING holidays

J

jacob

I've perused the existing posts and while I've come across some useful
postings, I couldn't seem to find my exact answer.

I simply want Excel to calculate the number of business days in any
given calendar month.

For instance:

Cell A1 = 07/01/04

Cell A2 = ..formula.. = 20

20 being the number of business days in July, minus weekends, minus the
july 4th holiday.

I understand I will have to use NETWORKDAYS function, with the Analysis
Toolpak installed, but what would the formula contain so that I am
getting the holidays to be taken out also, and would I need to create a
separate range with a date list of those holidays I wish to be taken
out? Thanks terribly! Jacob
 
B

Biff

Hi!

You're pretty much answering your own questions!

If you want to exclude holidays then yes, you have to list
them in a range.

A1 = 07/01/04 (I take that to be July 1 2004)

B1:B10 = list of holidays
Cell A2 = ..formula.. = 20
Click to expand...

=NETWORKDAYS(A1,EOMONTH(A1,0),B1:B10)

Returns 22

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

returning a date 7 business day excluding holidays in the future 2
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Date Calculation Formula- Calendar days minus Holidays 1
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Month days over a time period 5
Calculate days help 2
Working Days in a Named Month 1
Calculate the number of days to exclude Sunday & Holidays 6

Top