How to calculate workdays in a month?

**ExcelNewby** · 06-19-2008, 09:24 AM

Greetings- Does anyone know of an easy way to calculate business days in a month minus weekends and holidays?

TIA,
ExcelNewby

**NBVC** · 06-19-2008, 09:45 AM

The Networkdays() function should work for you. It is, however, an Analysis Toolpak function and therefore the Analysis Toolpak must be installed.

Go to Tools|Options|Addins and select the Analysis Toolpak...

example formula: =Networkdays(A1,B1,X1:X10)

Where A1 is Start date, B1 is End Date and X1:X10 contains holidays to ignore.

**ExcelNewby** · 06-19-2008, 10:05 AM

Thank you for your reply, it was greatly appreciated as always. Based on my manual calculation (ex. Jan 08=21), your formula included the holidays but not weekends (23-I'm going to assume the two days are New Year & MLK). How can I get it to exclude both weekends and holidays.

Thank you. Your cute boy is growing FAST

**NBVC** · 06-19-2008, 10:09 AM

According the help files on Networkdays function:

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

So not sure how it is including weekends

Note: If you holidays fall on the weekends, then the date is not double-counted...