I am trying to count the number of cells with a date within the last 7 days. CountIF supposedly supports expressions, but I cannot get it to recognize the following:

COUNTIF(J1:J80,">(Today()-7)")

The function will will work if I enter the date I want to see if the field is greater than =COUNTIF(J14:J31,">01/01/2003"), but I want the date to change for the current day...

Plz advise...

I've got a solution that works, but it involves setting a cell to Today()-7 and then entering: =COUNTIF('1.4A'!J2:J31,A9) + COUNTIF('1.4A'!J14:J31,A10) + COUNTIF('1.4A'!J14:J31,A11) + COUNTIF('1.4A'!J14:J31,A12) + COUNTIF('1.4A'!J14:J31,A13) + COUNTIF('1.4A'!J14:J31,A14+'1.4A'!G58) + COUNTIF('1.4A'!J14:J31,A15) + COUNTIF('1.4A'!J14:J31,A16)

but I don't like this impletmentation....