Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all , I hoping to get a function that is able to look at a series of dates and produce a
result from 1 to 30 .
Col F always contains a date , these change daily .
Cols CH to DK also contain dates . There are x 30 cols of dates so min and max result answer
can only be between 1 and 30 . If cells are blank in cols CH to DK answer is always 1 one .
The dates are always in ascending order across each row in cols CH to DK . The newest date is always in col DK ,
next older date will always be to left in col DJ and so until last oldest date when horse began its first ever race start .
I want to determine how many races a horse has had since starting its campaign this time around .
I would like the function to find the first date where there was a break of 40 days or more from the date in col F and start
counting the following dates including adding 1 for today's date in col F.
I have highlighted the dates in green where the function should start the count (after) following the green shaded areas .
Thanks .
result from 1 to 30 .
Col F always contains a date , these change daily .
Cols CH to DK also contain dates . There are x 30 cols of dates so min and max result answer
can only be between 1 and 30 . If cells are blank in cols CH to DK answer is always 1 one .
The dates are always in ascending order across each row in cols CH to DK . The newest date is always in col DK ,
next older date will always be to left in col DJ and so until last oldest date when horse began its first ever race start .
I want to determine how many races a horse has had since starting its campaign this time around .
I would like the function to find the first date where there was a break of 40 days or more from the date in col F and start
counting the following dates including adding 1 for today's date in col F.
I have highlighted the dates in green where the function should start the count (after) following the green shaded areas .
Thanks .
| Excel Workbook | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | F | CH | CI | CJ | CK | CL | CM | CN | CO | CP | CQ | CR | CS | CT | CU | CV | CW | CX | CY | CZ | DA | DB | DC | DD | DE | DF | DG | DH | DI | DJ | DK | GO | GP | |||
| 1 | ID | Date | Date30 | Date29 | Date28 | Date27 | Date26 | Date25 | Date24 | Date23 | Date22 | Date21 | Date20 | Date19 | Date18 | Date17 | Date16 | Date15 | Date14 | Date13 | Date12 | Date11 | Date10 | Date9 | Date8 | Date7 | Date6 | Date5 | Date4 | Date3 | Date2 | Date1 | Result | Help on result | ||
| 2 | 1 | 8/06/2012 | 17/03/2011 | 3/04/2011 | 10/04/2011 | 16/04/2011 | 7/05/2011 | 5/06/2011 | 25/06/2011 | 10/07/2011 | 31/07/2011 | 13/08/2011 | 21/08/2011 | 27/11/2011 | 18/12/2011 | 30/12/2011 | 12/01/2012 | 28/01/2012 | 4/02/2012 | 3/06/2012 | 2 | 120 | ||||||||||||||
| 3 | 2 | 8/06/2012 | 14/01/2012 | 21/04/2012 | 5/05/2012 | 3 | 98 | |||||||||||||||||||||||||||||
| 4 | 3 | 8/06/2012 | 7/04/2012 | 9/04/2012 | 22/04/2012 | 11/05/2012 | 18/05/2012 | 6 | 6th run including today 8/6/12 | |||||||||||||||||||||||||||
| 5 | 4 | 8/06/2012 | 9/04/2011 | 25/04/2011 | 30/07/2011 | 9/08/2011 | 12/09/2011 | 14/12/2011 | 15/01/2012 | 24/02/2012 | 16/03/2012 | 22/04/2012 | 3/05/2012 | 7 | 93 | |||||||||||||||||||||
| 6 | 5 | 8/06/2012 | 1 | First ever start | ||||||||||||||||||||||||||||||||
| 7 | 6 | 8/06/2012 | 11/06/2010 | 24/11/2010 | 22/12/2010 | 2/12/2011 | 16/12/2011 | 30/12/2011 | 1/02/2012 | 8/03/2012 | 16/03/2012 | 22/03/2012 | 29/03/2012 | 1/06/2012 | 2 | 64 | ||||||||||||||||||||
| 8 | 7 | 8/06/2012 | 1 | First ever start | ||||||||||||||||||||||||||||||||
Sheet1 | ||||||||||||||||||||||||||||||||||||
