Formula to count number of dates older than today

[coolwik]

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

 

[JE McGimpsey]

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.

 

[andy62]

=COUNTIF(A1:A6,"<5/1/2007")

 

[Bob Phillips]

=COUNTIF(A:A,">"&TODAY())

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[coolwik]

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.

Thanks JE. I deleted my post from the other group.

 

[coolwik]

=COUNTIF(A:A,">"&TODAY())

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Thanks everyone! It worked perfectly.

 

[Paul B]

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