Workday in Excell 1

[HeyFrantz]

Hi all!
Does anyone knows how to use the date funtions in excell to calculate how many workday in any particular month by simply imputing the month:
Example.....July has 22 workdays...
Thanx

 

[meintsi]

How about the function

NETWORKDAYS(startdate,enddate,holidays) *Remember.......
If you don't use your head,
your going to have to use your feet

 

[HeyFrantz]

Hey Meintsi!
I tried the that function...i was hoping for another option whereby I did not have to type the holidays and stuff like that!
any suggestion!
Thanx

 

[PeterMoran]

Hi,

If you put all your holiday dates for the year together in a range which you then name as holidays, then you don't have to worry about them each month, just once a year.

Your formula is still the same but "Holidays" covers the whole year:

=NETWORKDAYS(startdate,enddate,holidays)

Good Luck!

Peter Moran
"Two heads are always better than one."

 

[xlbo]

Sorry but there is no other function. Thinking about it logically, how could this possibly be implemented.....There are many different "working weeks" within the same country. Also, there are different religious holidays etc. There's no way M$ could create a function that "knows" when the holidays are because they change so much (take Easter for example) and some companies have 2 weeks off over Christmas...other companies work some bank holidays and others work all bank holidays. Sorry but IMHO, there is no possible way to do this without setting out the criteria for the holiday pattern within your specific company Rgds
~Geoff~

 

[HeyFrantz]

Thanx Peter!
Geoff-your logic is my dilema. I was shooting for more basic or standarg function without regard to race creed or sex...you know the basic holidays....I guess the problem is : basic can be interpreted in so many ways by so many people! Oh well, can't have it all!
Thanks man!
~Frantz

 

[xlbo]

Yeh - I know - it's a right little f*&^%r - needed the same kinda thing meself a while back and ran into a brick wall trying to solve it. If it's any help, setting up the list of holidays doesn't take too long and.....if what you're after is counting weekdays (ie Mon-Fri), I may be able to help -
=NETWORKDAYS("01-"&A1&"-"&YEAR(TODAY()),EOMONTH("01-"&A1&"-"&YEAR(TODAY()),0))

This will give the no. of WEEKDAYS (not including bank holidays) for a month typed in A1, for THIS year
Rgds
~Geoff~

 

[HeyFrantz]

Geoff- thanx....it was fun!
stay tuned for my next topic...(username)!
Frantz

 

[LarryDeLaruelle]

Peter:

I was going crazy trying to get the Networkdays to work.

Your reply gave me the clue I needed to figure out the Holiday range setup.

Thanks. Larry De Laruelle
ldelaruelle@familychildrenscenter.org