TODAY() function problem

  • Thread starter Thread starter Iriemon
  • Start date Start date
I

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