View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Count Dates between Dates exclude Text

Excel2003 ... Col "H" contains Dates (mm/dd/yy), Text comments & Empty Cells.

I wish to count dates by Qtr (excl Text) ... How many dates occurred between?

01/01/09 to 03/31/09
04/01/09 to 06/30/09
07/01/09 to 09/30/09
10/01/09 to 12/31/09

Sumproduct keeps giving me the "NUM" error ... Countif keeps counting the
Text.

Above said ... I am fully aware this is a short-coming on my part ... :)

Thanks for a solution ... Kha