The number 28232 result when using NETWORKDAYS function

S

seymourgomez

If the applicable beginning date cell is blank, I get the number 28232
result. How do I get rid of it?
 
D

Dave Peterson

=if(count(a1,c9)<2,"Missing a date",yourformulahere)

Change A1 and C9 to the cells you're looking at.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

networkdays alternative 2
Networkdays and misleading results from blank column 3
NETWORKDAYS 2
How can the font and size of (all) citation numbers be altered? 1
Remove title bar and phase bar by default on swimlane 0
Publisher adding blank page when printing my booklet... 2
Function or If statement help 1
Different results: Networkdays versus date subtraction 6

Top