Can I 'Countif' cells with dates from 'the last 7 days' etc

[niallmurph]

Hi,

I have what I'm sure is a simple question. Can I use a Countif function on a column of dates, asking it to only include dates from the last 7 days?

eg. =COUNTIF('Dates Sheet'!A:A,"THE LAST 7 DAYS")

where A:A is full of dates in DD/MM/YYYY format.

Hope this makes sense! Help appreciated.

 

[DonkeyOte]

=countif('dates sheet'!a:a,">"&today()-7)

 

[niallmurph]

thanks a lot!