Count records where date is within the last week
The below formula will count the number of dates in Column B which are within
the last week...
=COUNTIF(B:B,"" & TODAY()-7)
If this post helps click Yes
---------------
Jacob Skaria
"pmjb007" wrote:
I need to count the number of records that have had a date set within the
last week. For reporting other statistics in the same worksheet, i'm use
DCOUNTA, and i assumed i could do the same with this requirement, by using
the TODAY() function. I can't seem to get it to work:-
My data is:-
A B C
DQ001 01/06/2009 01/07/2009
DQ002 14/07/2009
I assumed i could use this:-
=DCOUNTA(A1:C2,"A",D1:E2)
with this criteria range
D E
B B
<today() today()-7
To produce a count of records where B is within the last week, in this case
the answer would be 1. I'm pretty sure the logic is ok, but can't get it to
work.
|