Amount of Workdays in a Month

[Mar10]

Greetings

Is there a way that I can calculate the amount of workdays per month,
excluding weekends? I have searched -
http://groups.google.com/group/micr...1bb6e438d2/d07323305638dafa#d07323305638dafa#
but the calculation includes the a six (6) day workweek, I need to
calculate a 5 day workweek.

Thank you and I appreciate your response.

Mart10

 

[Bob Phillips]

Just use =Networkdays(start_date,end_date)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Roger Govier]

Hi

With Month start in A1
=NETWORKDAYS(A1,DATE(YEAR(A1),MONTH(A1)+1,0))

Networkdays is part of the Analysis Toolpak.
Tools>Addins>check the box for Analysis Toolpak

 

[Jim Cone]

In A1 enter =DATE(2007,ROW(),1)
In B1 enter =DATE(2007,ROW()+1,0)
In C1 enter =NETWORKDAYS(A1,B1)

Fill all three cells down...
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Mar10"
<[email protected]>
wrote in message Greetings
Is there a way that I can calculate the amount of workdays per month,
excluding weekends? I have searched -
http://groups.google.com/group/micr...1bb6e438d2/d07323305638dafa#d07323305638dafa#
but the calculation includes the a six (6) day workweek, I need to
calculate a 5 day workweek.
Thank you and I appreciate your response.
Mart10

 

[Mar10]

Just use =Networkdays(start_date,end_date)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Thanks Bob, this did it!

 

[Mar10]

Hi

With Month start in A1
=NETWORKDAYS(A1,DATE(YEAR(A1),MONTH(A1)+1,0))

Networkdays is part of the Analysis Toolpak.
Tools>Addins>check the box for Analysis Toolpak

Thank You Roger, I needed to add the Toolpak before I could see the
function!

 

[Mar10]

In A1 enter =DATE(2007,ROW(),1)
In B1 enter =DATE(2007,ROW()+1,0)
In C1 enter =NETWORKDAYS(A1,B1)

Fill all three cells down...
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware

"Mar10"
<[email protected]>
wrote in message Greetings
Is there a way that I can calculate the amount of workdays per month,
excluding weekends? I have searched -http://groups.google.com/group/microsoft.public.excel.worksheet.funct...
but the calculation includes the a six (6) day workweek, I need to
calculate a 5 day workweek.
Thank you and I appreciate your response.Mart10

Another option! Thank you Jim.