Count dates In the past 7 days

[IssycrayG111]

I am trying to count a cell if it has a date with the range of the past 7 days, and I do not want to count blank cells. This is the closest I have gotten =COUNTIF(G3:I3,">="&TODAY()-7)-COUNTBLANK(G3:I3), but that’s giving me a negative number and I am not sure why. I am not even really sure if this is the right formula. I need help!!

 

[LlebKcir]

this maybe a real silly question, but why -countblank() at all? The countif should only count the dates in the range you have provided, if the cell is blank Excel will typically default to 1900 as the year so that is way outside of your 7 day range.

 

[IssycrayG111]

this maybe a real silly question, but why -countblank() at all? The countif should only count the dates in the range you have provided, if the cell is blank Excel will typically default to 1900 as the year so that is way outside of your 7 day range.

Probably because I don’t really know what I’m doing. I did try it without the count blank but it still didn’t seem to work.

 

[LlebKcir]

=COUNTIF(A1:C1,">"&TODAY()-7)

works just fine for me.

1/23/2020​	1/20/2020​	1/1/2020​	2​
1/23/2020​			1​
12/12/2019​	1/23/2020​	1/19/2020​	2​

 

[Fluff]

Welcome to MrExcel.
Judging by the fact that your dates are all aligned left, I suspect that they are text rather than real dates. This would explain why your formula doesn't work.
You will need to convert them to real dates.

 

[LlebKcir]

Fluff, would that generate a negative value instead of a zero?

 

[Fluff]

Which is what the OP is getting.