=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),EOMONTH(A1 ,0),Holidays)*8

For 8 hours workdays. Holidays is a range with holiday dates. Look in HELP for NETWORKDAYS() for details. A1 contains a date in
the appropriate month. The day doesn't matter.
If you get a #NAME error:
ToolsAdd-ins, check Analysis Toolpak.


"Mama Mia" wrote in message news | How do I calculate man hours for a month?