# TODAY() function problem

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

P

#### Pecoflyer

Iriemon;235755 said:
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

B

#### Bernard Liengme

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

C

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

C

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

P

#### Pecoflyer

Chip said:
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