Countif Dates fall within Range

[evanscm3]

Hi,
Sorry to come in with another CountIF question, but I checked some other threads and couldn't find anything that works for this..

I need to count the number of rows that contains a date that falls within the last 7 days. The dates are in one column (J in this example) - I am trying the below which just gives me 0s

=COUNTIF(J4:J26,">=(today()-7)")

Any help appreciated.
Thanks
Chris

 

[barry houdini]

You need to adjust the syntax a little, i.e.

=COUNTIF(J4:J26,">="&today()-7)

 

[evanscm3]

that works fantastically - thanks.
is it possible to add the top level of the range in the formula or does that fall beyond the scope of CountIF

for example if date is >=today()-7 & < today ()<TODAY() p ?<>

 

[barry houdini]

You can use 2 COUNTIFS like this

=COUNTIF(J4:J26,">="&today()-7)-COUNTIF(J4:J26,">="&today())

which counts the last 7 days (not including today)

or you can use SUMPRODUCT, i.e.

=SUMPRODUCT((J4:J26>=TODAY()-7)*(J4:J26< TODAY()))<TODAY()))< p>