Bad data somewhere as the formula is OK

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gregory Day" wrote in message
...
On sheet two I have a column of dates formatted as 3/28/2008. I would like
to
add
a cell on Sheet1! that looks at that column and counts the number of
entries
that are 180 days prior to today or higher.I tried this with out luck.

=COUNTIF(Clients!AC4:AC113,(TODAY()-180))

but it just gave me 0 though there was 1 in the column.
--
Thank you,

Gregory