ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Generating business days in a calendar month, EXCLUDING holidays (https://www.excelbanter.com/excel-worksheet-functions/21557-generating-business-days-calendar-month-excluding-holidays.html)

jacob

Generating business days in a calendar month, EXCLUDING holidays
 
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



All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com