Count Days more than 180 days prior to today

G

Gregory Day

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.
 
S

Sandy Mann

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count dates falling in a certain range 6
Count IF 1
formulas to count dates 2
excel today countif over expired date 2
Formula to count number of dates older than today 6
Mutiple COUNTIF or equivalent. 8
Count the Days in a Range if 1
Counting Work Days 5

Top