Count between a Date Range

  • Thread starter Thread starter Miguelre
  • Start date Start date
M

Miguelre

I have a number of columns that has dates in them and blank cells, and
would like to count the number of instances a date’s falls in betwee
current date and earlier. I have not been successful using the eithe
the Countif ,Sumif, or Sumproduct formula.

Can someone please assist me, because I have been racking my brain ove
this for 3 days now
 
Hi
try:
=SUMPRODUCT(--(A1:A100>=DATE(2004,9,1)),--(A1:A100<=TODAY()))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
Excel Sumproduct 0
Counting dates but only for a certain year 2
SUMIF using date ranges & referencing account numbers 1
Formula to count specific items in a certain date range. 6
Count Unique Cells, within a date range (dates stored in separatecolumn). 3
Counting number of dates that occur within a week - per market 4
Counting Between Dates 3

Back
Top