Dear Board,
I have a Column which contains dates serially starting from any date of the month and ending at any date but all these dates would be in chronolgical order..
Example:
Lets say the dates are stored in the Column B and they start from 12-Apr-2013 till 12-May-2013..then I want some formula in the adjoining column Column C which shows the Date 12_apr-2003 or the address of the first occurence of the most smallest date in the COlumn B...
So lets say Cell B2= 12-Apr-2013 till Cell B3 = 13-Apr-2013 so on so forth till Cell B32
<colgroup><col><col><col></colgroup><tbody>
</tbody>
So I need to get a formula which will give me the address of the cell containing the most smallest date in the recurring month for that year I need the formula for RUNNING values..
I have a Column which contains dates serially starting from any date of the month and ending at any date but all these dates would be in chronolgical order..
Example:
Lets say the dates are stored in the Column B and they start from 12-Apr-2013 till 12-May-2013..then I want some formula in the adjoining column Column C which shows the Date 12_apr-2003 or the address of the first occurence of the most smallest date in the COlumn B...
So lets say Cell B2= 12-Apr-2013 till Cell B3 = 13-Apr-2013 so on so forth till Cell B32
Cell B2 | 12-Apr-13 | B2 |
Cell B3 | 13-Apr-13 | B2 |
Cell B4 | 14-Apr-13 | B2 |
Cell B5 | 15-Apr-13 | B2 |
Cell B6 | 16-Apr-13 | B2 |
Cell B7 | 17-Apr-13 | B2 |
Cell B8 | 18-Apr-13 | B2 |
Cell B9 | 19-Apr-13 | B2 |
Cell B10 | 20-Apr-13 | B2 |
Cell B11 | 21-Apr-13 | B2 |
Cell B12 | 22-Apr-13 | B2 |
Cell B13 | 23-Apr-13 | B2 |
Cell B14 | 24-Apr-13 | B2 |
Cell B15 | 25-Apr-13 | B2 |
Cell B16 | 26-Apr-13 | B2 |
Cell B17 | 27-Apr-13 | B2 |
Cell B18 | 28-Apr-13 | B2 |
Cell B19 | 29-Apr-13 | B2 |
Cell B20 | 30-Apr-13 | B2 |
Cell B21 | 01-May-13 | B21 |
Cell B22 | 02-May-13 | B21 |
Cell B23 | 03-May-13 | B21 |
Cell B24 | 04-May-13 | B21 |
Cell B25 | 05-May-13 | B21 |
Cell B26 | 06-May-13 | B21 |
Cell B27 | 07-May-13 | B21 |
Cell B28 | 08-May-13 | B21 |
Cell B29 | 09-May-13 | B21 |
Cell B30 | 10-May-13 | B21 |
Cell B31 | 11-May-13 | B21 |
Cell B32 | 12-May-13 | B21 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
So I need to get a formula which will give me the address of the cell containing the most smallest date in the recurring month for that year I need the formula for RUNNING values..