Formula Errors

Fix Excel NETWORKDAYS Returning January 0 1900 for Blank Dates

Adam DavisAdam Davis Oct 19, 2026 873 views

Question details

The user needs to prevent the NETWORKDAYS formula from calculating incorrect dates when referencing blank start-date cells.

Fix Excel NETWORKDAYS Returning January 0, 1900 When Start Date is Missing
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.
Before you start

Ensure the cells containing your dates are formatted properly as 'Date' rather than 'General' or 'Text' to avoid additional calculation errors.

Solution 1Recommended

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.

1
Select the result cell

Click on the cell where you want the NETWORKDAYS result to appear, for example, cell F5.

2
Enter the nested IF and NETWORKDAYS formula

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.

3
Fill down the formula

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.

Use an IF Statement to Check for Blank Start Dates
Require Both Dates to Calculate: If you want the formula to remain blank unless both the start and end dates are filled, use the OR function like this: =IF(OR(D5="",E5=""),"",NETWORKDAYS(D5,E5)-1).
Manage Spreadsheets Efficiently

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing your project dates.
  2. 2. Apply the combined formula: Select the target cell and enter =IF(D5="","",NETWORKDAYS(D5,E5)) to safely calculate working days.
  3. 3. Drag to fill: Use the fill handle at the bottom right of the cell to apply the formula down your column instantly.
Fully compatible with Microsoft Excel formulas and date formattingFree, lightweight, and fast to loadBuilt-in error checking for complex nested functions like IF and NETWORKDAYS
microsoft office alternative - wps office

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).