|
TODAY() function problem
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 |
TODAY() function problem
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 |
TODAY() function problem
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 |
TODAY() function problem
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 |
TODAY() function problem
=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()") |
TODAY() function problem
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 |
| All times are GMT +1. The time now is 07:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com