Countif function for date range

  • Thread starter Thread starter Komatsu
  • Start date Start date
K

Komatsu

Column 'A' has beginning dates Column 'B' has Ending dates. Column 'C'
has dates to search by. 'D' will show results (qty).
Formula should count the times the date, 'C1' is equal to or between
rows adjacent dates in 'A' and 'B'. Continue to compare 'C1' to
'A2','B2'... 'A3', 'B3'....'A999','B999' (last record).
Then go to nest date to search by, 'C2' with results in 'D' column.
 
In D1

=SUMPRODUCT((A$1:A$999>=C1)(*B$1:B$999<=C1))

and then just copy down into D2, D3, etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Didn't work. Returned '0' in every cell.
It looked like the '*' was in the wrong place... I moved it between the
() to make it look like (*) but that didn't help ether.
Any other suggestions?
 
Back
Top