niallmurph
New Member
- Joined
- Jun 11, 2008
- Messages
- 16
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.
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.