Thanks you all. It is fixed!
--
Thank you,

Gregory


"Gregory Day" wrote:

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