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

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()")


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65800

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Iriemon" wrote in message
...
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

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)


On Wed, 18 Feb 2009 05:27:01 -0800, Iriemon
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

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

Chip Pearson;235920 Wrote:
=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
'Excel Redirect' (http://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()")

Thx Chip emb1


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65800