Counting the number of business days in a year

  • Thread starter Thread starter bodem96
  • Start date Start date
B

bodem96

Hi,

Please accept my apologies if I don`t make sense since this is my firs
posting on this website.

I am trying to have excel calculate the number of business days in
given year.

Also, I wanted to know if it would be possible to create new sheet
automatically for business days in a month.

Please helpppp.

Thank you all in advanc
 
If you are wanting to count the amount of days Mon - Fri and to take into
account holidays then the following should help (make sure you have the
Analysis Tool Add In installed)

=NETWORKDAYS(A1,A2,A3:A10))

The startdate is in cell A1, the end date is in A2 and a list of holidays is
in the range A3:A10

HTH
 
Hi
if A1 stores the year try
=NETWORKDAYS(DATE(A1,1,1),DATE(A1+1,1,1),list_of_holidays)

Note: you may have to activate the Analysis Toolpak Add-in for this
 
Hi Frank!

Small problem here!

=NETWORKDAYS("1-Apr-2004","2-Apr-2004")
Returns 2

Demonstrating that NETWORKDAYS counts both the starting day and the
ending day in it's count.

But since in most countries 1-Jan is a Public holiday your formula:

list_of_holidays includes just 1-Jan-2004 and 1-Jan-2005

A1: 2004
=NETWORKDAYS(DATE(A1,1,1),DATE(A1+1,1,1),list_of_holidays)
Returns: 261

The correct version
=NETWORKDAYS(DATE(A1,1,1),DATE(A1,12,31),list_of_holidays)
Returns: 261

One reason that you won't see a difference if you don't include
1-Jan-2005 in your list of holidays is that 1-Jan-2005 is a Saturday.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top