View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
watermt watermt is offline
external usenet poster
 
Posts: 82
Default Excel 2003: Count total days elapsed

I need to count the total number of days (counting all days of the week)
elapsed between process 1 through 12. Using the m/d/yyyy hh:mm cell
formatting, not all 12 processes will have a date/time entered (blank cell).

When I use the following function; =NETWORKDAYS(F1,F12) and I have a blank
cell (i.e., F9) I get the #Name? error. Is there a way to have the function
ignore blank cells?

And finally, which function do I use to count all 7 days of the week?

Mike