View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CM CM is offline
external usenet poster
 
Posts: 136
Default formula for days between completed meetings

Here's the deal. I have 10 meeting dates (some may be blank) and 10 columns
beside each that are either blank (meaning completed) or have the word
'Missed', as such:

A B C D E
1/2/09 (blank) 1/4/09 Missed 1/5/09 (blank) etc etc

Too many to use nested IFs.

I have been asked to calculate the average days between non-missed meetings.
Some of the meeting date cells will be blank. I would appreciate any advice.

--
cm