S seymourgomez Mar 18, 2008 #1 If the applicable beginning date cell is blank, I get the number 28232 result. How do I get rid of it?
If the applicable beginning date cell is blank, I get the number 28232 result. How do I get rid of it?
D Dave Peterson Mar 18, 2008 #2 =if(count(a1,c9)<2,"Missing a date",yourformulahere) Change A1 and C9 to the cells you're looking at.
=if(count(a1,c9)<2,"Missing a date",yourformulahere) Change A1 and C9 to the cells you're looking at.
