Formula to count number of dates older than today

  • Thread starter Thread starter CW
  • Start date Start date
C

CW

Hello!

Say today's date is 5/1/2007 and I have a column with dates that looks
like this:

DATE
4/27/2007
4/29/2007
4/30/2007
5/1/2007
5/2/2007
5/3/2007

I need a formula that will count the number of dates that are older
than today. For instance, for this list, the formula will output the
number 3.

I've tried COUNTIF and DCOUNT and I couldn't get either to work.

Any idea? Thanks.

-Mike
 
See one answer in microsoft.public.excel

Please don't post the same message in multiple groups. It just fragments
any answers you get, and may waste the time of those answering questions
that have already been answered.
 
See one answer in microsoft.public.excel

Please don't post the same message in multiple groups. It just fragments
any answers you get, and may waste the time of those answering questions
that have already been answered.
Click to expand...

Thanks JE. I deleted my post from the other group.
 
Something like this,

=COUNTIF(A1:A10,"<"&TODAY())
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

wrote in message
news:[email protected]...
 
Back
Top