Fix Excel NETWORKDAYS Returning January 0 1900 for Blank Dates
Question details
The user needs to prevent the NETWORKDAYS formula from calculating incorrect dates when referencing blank start-date cells.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Filling down the NETWORKDAYS formula across a worksheet where some rows have missing start dates.
- Observed behavior
- Excel treats blank start-date cells as zero, causing the formula to calculate incorrect date values and display January 0, 1900 based on cell formatting.
Ensure the cells containing your dates are formatted properly as 'Date' rather than 'General' or 'Text' to avoid additional calculation errors.
Use an IF Statement to Check for Blank Start Dates
Wrap your NETWORKDAYS formula in an IF function to return a blank string instead of an error when the start date is missing.
By combining the IF function with NETWORKDAYS, you can instruct Excel to verify if the target cell is empty before attempting a calculation. This prevents the default behavior of treating blanks as zero.
Click on the cell where you want the NETWORKDAYS result to appear, for example, cell F5.
Type =IF(D5="","",NETWORKDAYS(D5,IF(E5="",TODAY(),E5))-1) into the formula bar. This checks if D5 (start date) is blank. If true, it returns blank; if E5 (end date) is blank, it uses today's date.
Press Enter, then click and drag the fill handle at the bottom-right corner of the cell down to apply this updated formula to the rest of your worksheet rows.

Calculate Workdays Flawlessly in WPS Spreadsheet
WPS Office provides a powerful, free spreadsheet tool that fully supports the NETWORKDAYS and IF functions, making it simple to manage project timelines without date formatting glitches.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing your project dates.
- 2. Apply the combined formula: Select the target cell and enter =IF(D5="","",NETWORKDAYS(D5,E5)) to safely calculate working days.
- 3. Drag to fill: Use the fill handle at the bottom right of the cell to apply the formula down your column instantly.

Frequently Asked Questions
Why does Excel show January 0, 1900 instead of a blank?
Excel's default date system starts on January 1, 1900. When a formula references a blank cell, Excel treats the blank as a zero. A zero value in the date system evaluates to the non-existent date of January 0, 1900.
Does the NETWORKDAYS formula include weekends?
No, the NETWORKDAYS function automatically excludes standard weekends (Saturday and Sunday). If you need to specify custom weekend days, you should use the NETWORKDAYS.INTL function instead.
How do I exclude holidays from my NETWORKDAYS calculation?
You can add an optional 'holidays' argument to the formula. Create a list of holiday dates in a separate range, and reference it at the end of the formula, such as =NETWORKDAYS(Start_Date, End_Date, Holiday_Range).




