NETWORKDAYS
Posted by Matthew Schmitt on May 08, 2001 8:45 AM
I have the following formula:
=NETWORKDAYS((C41),(TODAY()),{36892,37040,37076,37137,37217,37250})-1
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
Matthew
You're going to kick yourself for this but...
All you need to do is prefix your NETWORKDAYS statement with an IF as follows:
=IF(C41="","",NETWORKDAYS((C41),(TODAY()),{36892,37040,37076,37137,37217,37250})-1)
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).
JAF
