| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how I exclude weekend dates | Setting up and Configuration of Excel | |||
| Using Autofilter to exclude dates | Excel Worksheet Functions | |||
| Count dates -in text format- in October | Excel Worksheet Functions | |||
| I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Threaded Mode
