TODAY() function problem

[Iriemon]

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

 

[Pecoflyer]

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 sam
result.

Any help corecting this would be greatly appreciated.

Thanks

Iriemon

Maybe

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

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Bernard Liengme]

How about =COUNTIF(B18:B377,"<="&TODAY())

This might also work =MATCH(TODAY(),B18:B377,1)
Or =INDEX(A16:A377,MATCH(TODAY(),B16:B377,1)) which has the logic of your
formula
best wishes

 

[Chip Pearson]

If all you need is to count the number of occurrences less than or
equal to today, use the following formula:

=COUNTIF(B18:B377,"<="&TODAY())

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

 

[Chip Pearson]

=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)

 

[Pecoflyer]

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
'Excel Redirect' (http://www.cpearson.com)
(email on web site)

Thx Chip emb

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste