Forum Discussion
Count Dates in Range Based on Criteria
I have the below column of dates in a named range. 9/1/2020 9/8/2020 9/9/2020 9/10/2020 9/15/2020 9/20/2020 9/22/2020 9/28/2020 9/29/2020 10/1/2020 10/2/2020 1...
The syntax of the criterion field was not correct
The formula ">Today()-7" will not evaluate the way you want inside the quotes.
Try
= COUNTIF(dates,">"&(TODAY()-7))
Thanks for the reply! That is exactly what I was trying to do. When I looked at the CountIf help subject last night, I did not see that option. But looking at it again today, I see that it is indeed in there. The help gives this example:
=COUNTIF(B2:B5,"<>"&B4)
|
Should have seen that before!
Again, thanks for the help!
--Tom