Count how many rows with a date within the next 7 days

[Teblol]

Hi guys,

Is there a formula that can count how many rows in column E equal todays date plus 7 days? I know that the below formula counts how many rows have today's date, but I cannot find a formula to count how many rows have a date between today's date (11/11/2014) to 7 days out (12/18/2014).

=COUNTIF(E:E,TODAY())

[Ron Coderre]

Try this:

=COUNTIF(E:E,TODAY()+7)

Is that something you can work with?

[Teblol]

I had tried that prior to posting, but for some reason it returns 0. I have 9 dates in column E that have a date between 11/11/2014 to 11/18/2014 so the formula should return a 9.

[Ron Coderre]

That would imply that either the Col_E values are not dates....
or...they include a time component (Example: 12/18/2014 4:48:00 AM).
Assuming the latter, try this:

=COUNTIFS(E:E,">="&TODAY()+7,E:E,"<"&TODAY()+8)

or...if you want a count of dates that are between today and today +7 days, inclusive,
try this:

=COUNTIFS(E:E,">="&TODAY(),E:E,"<"&TODAY()+8)

Does that help?

[Teblol]

The column E values are definitely dates, and they do not have a time component.

Capture.JPG

[MarvinP]

How about something like this?

=COUNTIF(E:E,TODAY()) +COUNTIF(E:E,TODAY()+1) +COUNTIF(E:E,TODAY()+2) +COUNTIF(E:E,TODAY()+3) +COUNTIF(E:E,TODAY()+4) +COUNTIF(E:E,TODAY()+5) +COUNTIF(E:E,TODAY()+6) +COUNTIF(E:E,TODAY()+7)

[Teblol]

This works, thanks. I would have thought there would be a simplified version of this?

=COUNTIF(E:E,TODAY()) +COUNTIF(E:E,TODAY()+1) ++COUNTIF(E:E,TODAY()+2) ++COUNTIF(E:E,TODAY()+3) ++COUNTIF(E:E,TODAY()+4) ++COUNTIF(E:E,TODAY()+5) ++COUNTIF(E:E,TODAY()+6) ++COUNTIF(E:E,TODAY()+7)

[MarvinP]

Hi,

Ron's formulas above that use the CountIFS() is an easier version.

[Teblol]

Somehow I had missed your second formula, Ron. It worked beautifully. I never would have thought of it. Thanks so much for the help. +1 for both of you.

=COUNTIFS(E:E,">="&TODAY(),E:E,"<"&TODAY()+8)

This thread will be changed to "solved".