MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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