Help with date (today) formula

[dkballs]

Hi, Please help. I have a spreadsheet and I need a cell that displays how many dates in a given column are greater than (younger) todays date.

I have tried =COUNTIF(A2:A7,">today()")

but the value is always 0.

If i replace today() with a date e.g 03/05/2011 the formula shows the correct quantity of cells in excess of the 03/05/2011. I need the formula to autoupdate with todays date though as it will be a working spreadsheet.

Help please!!

 

[MrKowz]

Welcome to the forums!

Try:

=COUNTIF(A2:A7,">"&today())

 

[njimack]

Welcome to the board. Note the position of the quote marks.
=COUNTIF(A2:A7,">"&TODAY())

 

[dkballs]

Unbelieveable. That's taken up 2 hours of messing about on google and you have resolved it in under 3 minutes.

Thankyou so much

 

[njimack]

It was 2 minutes actually, but who's counting!