Check column of dates against todays date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of dates that I need to sort through. At the moment I am using

=COUNTIF(E8:E1000,"<15/04/2005")

to check dates that were before todays date. Now I would like to have this
formula change with the date. I have tried having a cell with =TODAY() in it
then referencing that cell in the formula:

=COUNTIF(E8:E1000,"<A1") but it just returns 0. Any ideas?

Hope so!!
 
Andrew,

Try

=COUNTIF(E8:E1000,"<"&TODAY())

or

=COUNTIF(E8:E1000,"<"&A1)


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

countifs Function not giving desired result with date criteria 2
Formula Referencing Columns By Date 2
Counting cells in a selectable date range 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Adding dates in columns 2
Function to Return a Date Value Q 4
Question 1 of ??? 3
How can I check whether a column of dates are all before today's d 3

Back
Top