Amount of Workdays in a Month
 

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/micro...323305638dafa#
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

Amount of Workdays in a Month
 

Just use =Networkdays(start_date,end_date)

--
HTH

Bob

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

"Mar10" wrote in message
oups.com...
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/micro...323305638dafa#
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

Amount of Workdays in a Month
 

Hi

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

Networkdays is part of the Analysis Toolpak.
ToolsAddinscheck the box for Analysis Toolpak
--
Regards

Roger Govier


"Mar10" wrote in message
oups.com...
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/micro...323305638dafa#
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

Amount of Workdays in a Month
 

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"

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/micro...323305638dafa#
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

Amount of Workdays in a Month
 

On May 22, 9:21 am, "Bob Phillips" wrote:
Just use =Networkdays(start_date,end_date)

--
HTH

Bob

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

"Mar10" wrote in message

oups.com...

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/micro...orksheet.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

Thanks Bob, this did it!

Amount of Workdays in a Month
 

On May 22, 9:25 am, "Roger Govier"
wrote:
Hi

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

Networkdays is part of the Analysis Toolpak.
ToolsAddinscheck the box for Analysis Toolpak
--
Regards

Roger Govier

"Mar10" wrote in message

oups.com...

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/micro...orksheet.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

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

Amount of Workdays in a Month
 

On May 22, 9:37 am, "Jim Cone" wrote:
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"

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.