View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mar10 Mar10 is offline
external usenet poster
 
Posts: 4
Default 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!