Previous Topic Next Topic

Counting Range of dates over 1 year old

Closed
Andreja - Jun 9, 2009 at 04:37 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 9, 2009 at 05:52 AM
Hello,

I am pulling out the remainder of little hair I have on my head.

Question:
I have a column of dates and what I want to do is count the column of dates that are over 1 year old. I have managed to put a conditional format of dates in place that are over 1 year. Please help as I despretely can't figure this one out.

J
Related:

1 reply

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jun 9, 2009 at 05:52 AM
Hi
use the formula =COUNTIF(Range,"<" & NOW()-365)
0