Count Days more than 180 days prior to today
 

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

Count Days more than 180 days prior to today
 

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

Count Days more than 180 days prior to today
 

I've just responded to your other post.

Pete

On Mar 28, 9:45*pm, 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

Count Days more than 180 days prior to today
 

If you want from 180 days ago to today and assuming that there are no dates
later than today, then use:

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


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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

Count Days more than 180 days prior to today
 

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