Calculating Working Days In Month

[Kevan G]

I'm using Excel 2003 and my problem is I need to be able to calculate
how many working days there are in a month (Monday-Friday), that I can
deal with.

The second problem is I also need to calculate how many working days
there are in the month if the working week is expanded to include
Saturday, another way of looking at this possibly is number of days in
month less number of Sundays.

In case it is relavent the dates are in the range 01/01/1997 to
31/12/2006.

Can anybody help?

TIA
Kevan

 

[Gerrit-Jan Linker]

I tried to develop a function for this but it is difficult since the
number of working days will also involve public holidays. Perhaps I
can write a function to retrieve the number of weekdays (not weekend
days). I have already created a DaysInMonth, DaysInQuarter and
DaysInYear function in my LITlib Excel functions library.

Perhaps you would like to have a look at LITlib: www.oraxcel.com
Specifically, please have a look at www.oraxcel.com/projects/litlib

Best regards, Gerrit-Jan Linker
www.oraxcel.com

 

[Gerrit-Jan Linker]

For information:

I have now actually built in the functions to retrieve working days
and weekend days in LITlib (www.oraxcel.com/projects/litlib)

WeekDays(Date1, Date2): Calculates the working days (Mon-Fri) between
the 2 dates
WeekEndDays(Date2,Date2): Calculates the weekend days (Sat-Sun)
between the 2 dates.

Hope this helps,

Gerrit-Jan Linker
www.oraxcel.com