Count If Statement Using Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
try
=sum(if(today()-range<7,1,0)) entered as an array control-shift-enter
and
=sum(and(today()-range>7,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
 
Back
Top