count between start date and end date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I Have Start date and end date (MMM/YY) format

what I want is for each month, a sum of records which has a start date or
end date
and between them.

For example. Feb 06 : would have all records between with Feb06 start date
or end date. and date in between ( i.e, Start date Dec 05 end date Apr 06)
 
try
=sumproduct((daterng>a2)*(daterng<=a3))
to sum
=sumproduct((daterng>a2)*(daterng<=a3)rngtosum)
ranges must be the same size and not entire columns.
 
sorry am a bit confused.. which one of the two?


Don Guillett said:
try
=sumproduct((daterng>a2)*(daterng<=a3))
to sum
=sumproduct((daterng>a2)*(daterng<=a3)rngtosum)
ranges must be the same size and not entire columns.
Click to expand...
 
sorry aboutt his again..but what is a2 and a3?

I have start date in column D and end date in column e
 
Is there a thinking cap store in your neighborhood?

daterng a2:a200
a2 a start date put in this cell.
 
Back
Top