=countif(a18:a377,"<=today()")

You have the quotes in the wrong locations. Use

=countif(a18:a377,"<="&today())

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 18 Feb 2009 13:48:02 +0000, Pecoflyer
wrote:


Iriemon;235755 Wrote:
I have data arranged like this:

No. Payment Date
1 1-Sep-08
2 1-Oct-08
3 1-Nov-08
4 1-Dec-08
5 1-Jan-09
6 1-Feb-09
7 1-Mar-09
8 1-Apr-09
9 1-May-09
10 1-Jun-09
11 1-Jul-09
12 1-Aug-09
13 1-Sep-09
14 1-Oct-09
15 1-Nov-09
16 1-Dec-09
etc......

I tried using this formula to count the number of payments made:

=INDEX(A18:A377,MATCH(TRUE,INDEX(B18:B377<=TODAY() ,),0))

but it returns a value of 1.

I also tried using "NOW()" instead of "TODAY()" but get the same
result.

Any help corecting this would be greatly appreciated.

Thanks

Iriemon

Maybe

=countif(a18:a377,"<=today()")