Count If Statement Using Dates
 

I want to check a spreadsheet and count the cell based on dates. If the date
in the cell is less than 7 days before today then count. Then another count
if for if the date is 8 to 30 days before today. Any suggestions would be
greatly appreciated.

Count If Statement Using Dates
 

try
=sum(if(today()-range<7,1,0)) entered as an array control-shift-enter
and
=sum(and(today()-range7,today()-range<=30,1,0)entered as array

what happens when it is 7 days exactly? you may need to add an = to one of
the equations

"Chris O''''Neill" wrote:

I want to check a spreadsheet and count the cell based on dates. If the date
in the cell is less than 7 days before today then count. Then another count
if for if the date is 8 to 30 days before today. Any suggestions would be
greatly appreciated.