# WORKDAY and NETWORKDAYS Functions

Both the WORKDAY and NETWORKDAYS functions are essential for project planning. The WORKDAY function allows you to calculate the completion date provided that you know the number of days that is required to complete the project. The NETWORKDAYS function does the opposite. You have a desired completion date and you want Excel to calculate how many working days from the starting date to the desired completion date. By using either function, you can have better ideas how to manage the available resource or if you need to ask for more resources to commit to such project.

WORKDAY Function

Syntax: WORKDAY(start_date, days, [holidays])

You can omit the last parameter (holidays) if you only want to use Excel to exclude the weekends from calculations. However, it is definitely more practical if you can include the holidays. The holiday parameter can be only one cell if you expect there is only one holiday within the project span, or you can put in a range of holidays like from A1:A10. The range of holidays can be beyond the project life span. For example, the project may last for 3 months but you can include a whole year of holidays. Excel will pick up the relevant holidays and exclude the ones that are beyond the project life span.

Below illustration shows the calculation of WORKDAY function. The completion date will be quite different if you exclude the holidays from the calculation, especially if the project proceeds during the holiday season. The last parameter (‘Holiday List’!F2:F51) is calculated separately using a VB module that I created. Please refer to this article (US Holidays Calculation) for more information.

NETWORKDAYS Function

Syntax: NETWORKDAYS(start_date, end_date, [holidays])

Below illustration shows the use of NETWORKDAYS. It is used to calculating the number of working days if you put in a desired Project End Date. It shares the same logic as WORKDAY but just works the opposite way.

### Excel Vlookup Function

The VLOOKUP function in Excel is a powerful tool that allows you to search for a specific value in a table and return a corresponding

### Convert XLSX to PDF – Quick, Easy, Free

Why convert an XLSX to PDF?  Very often we’re presented with an XLSX file that needs to somehow be sent to others as a PDF.

### What Is an XLSX File? 9 Ways to Open It Fast and Easy!

What is an XLSX file? An XLSX file is the file format of a Microsoft Excel spreadsheet. Excel files are used to store data as

### Data Referencing by using VLOOKUP, HLOOKUP, MATCH, and INDEX functions

There are several functions can do data referencing: LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX, and OFFSET. VLOOKUP and HLOOKUP are partly covered in this article