# Use the NETWORKDAYS.INTL Function to Calculate Workdays Using Excel 2010

0
2761

In Excel 2010, Microsoft introduced a new formula to complement the NEWORKDAYS formula that exists in previous versions of Excel. NETWORKDAYS allows you to calculate the number of workdays in a given time period including holidays. In the new version of the equation for Excel 2010 you can specify when the the weekend falls in the week. So if your weekends are Monday and Tuesday, the function will be able to give you a more accurate result. The function also allows you to specify 1 day â€œweekendsâ€ should you need that option. In the how-to below I will walk you through the new function and the arguments that can be used.

If you have any comments or questions, please post them below. If youâ€™re new to Functions in Excel, read 3 Ways to Enter Formulas in Excel 2010 to become familiar with their use.

Note: I used Excel 2010 for this tutorial. The NETWORKDAYS function is available in Excel 2007, however NETWORKDAYS.INTL is not.

1. Click on the cell you wish to enter the formula into.

2. Click on the Insert Function button.

3. When the Insert Function window opens, click on NETWORKDAYS.INTL from the functions list.

4. Click OK.

5. Enter the following arguments:

• Start_date â€“ The dates need to be entered using the following format â€“ date(year, month, day).
• End_date – The dates need to be entered using the following format â€“ date(year, month, day).
• Weekend â€“ refer to table below.
• Holidays â€“ Can be entered manually using the same method above or if you have a list or an array refer to that instead.

6. Once you have entered the arguments, click OK to proceed.

The result should appear in the cell you selected.

Weekend Table â€“ The default value will be Saturday and Sunday, but if you wish to specify another weekend day you can use the values from the table below.

Table adapted from Excelâ€™s Help guides.

Previous articleHow to Add a Header and Footer to Excel 2010 Spreadsheets
Gilbert is a Microsoft MVP, a full-time blogger, and technology aficionado. When Gilbert is away from his bike and his iPad, he's busy writing technology how-to's from his home-office in Miami, Florida on the latest programs and gadgets he can get his hands on. He's locally known as "the computer guy" and has spent the last 12 years helping family, friends, and GilsMethod.com visitors with their computer questions and problems. He was awarded the 2009 MVP award from Microsoft for his contributions in forums and blogs and is enjoying the new addition to his family.