MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Matthew Schmitt on May 08, 2001 8:45 AM

I have the following formula:


If C41 is empty, Excel assumes that the date serial number is 0(01/01/1900). How do I get Excel to recognize the empty cell as a null value instead of 0? I am doing countif statements based on the age of the item the formula gives, and I also don't really want to see 26,440 as the age on lines of the sheet I am not currently using.

Posted by JAF on May 08, 2001 8:59 AM


You're going to kick yourself for this but...

All you need to do is prefix your NETWORKDAYS statement with an IF as follows:

That way the cell containing the NETWORKDAYS formula will be blank (or you can modify by specifying a zero or N/A value - whatever works for you).