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.