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!