View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default The number 28232 result when using NETWORKDAYS function

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

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

seymourgomez wrote:

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


--

Dave Peterson