counting working days in current month

I tried searching for this because I remember someone posting a link to what I think would help but cannot find it. Anyway.

I need a formula that returns the number of working days in the month up to the current day.

i.e. on the 14th of june it would return the value 10.

could someone point me in the right direction on that one?

Originally Posted by pjoaquin

Something like this should work:

=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(1)),TODAY())

From June 1 to June 13 there are 9 work days, though. (Unless you're writing from somewhere where it is already Thursday June 14th, then 10 is correct.)

haha, I was assuming that it was the 14th cause it's real late where I am I figured no one would be reading tonight.

thanks for the formula though, can't wait to try it out.

hmmm, i copy/pasted the function and it comes back with ?NAME error.

any suggests?

Install the analysis toolpack. Tools -> Add-ins, analysis ToolPak.

gah, I thought I had all those installed already. Thanks for the help folks, I think I finally figured out the DATE functions now, this formula was the perfect learning example for me.

Hats off to you all!