Identifying Row Number Based on Date

[Steve 1962]

Hi

Looking for formulas in cells A15 to B17 which give the first (Start) and last (End) row number of the months shown in column C.

Thanks

Book1.xlsx
	A	B	C
1	Text
2	Text
3	01/10/21
4	10/10/21
5	17/10/21
6	21/10/21
7	01/11/21
8	02/11/21
9	17/11/21
10	06/12/21
11	21/12/21
12	25/12/21
13
14	Start	End
15	3	6	Oct
16	7	9	Nov
17	10	12	Dec
Sheet1

 

[DanteAmor]

How about:

Dante Amor
	A	B	C
1	Text
2	Text
3	01/10/2021
4	10/10/2021
5	17/10/2021
6	21/10/2021
7	01/11/2021
8	02/11/2021
9	17/11/2021
10	06/12/2021
11	21/12/2021
12	25/12/2021
13
14	Start	End
15	3	6	01/10/2021
16	7	9	01/11/2021
17	10	12	01/12/2021
Hoja2

Cell Formulas
Range	Formula
A15:A17	A15	=MIN(IF(MONTH($A$3:$A$12)=MONTH($C15),ROW($A$3:$A$12)))
B15:B17	B15	=MAX(IF(MONTH($A$3:$A$12)=MONTH($C15),ROW($A$3:$A$12)))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Steve 1962]

Thanks Dante -

I have use the suggestion above and was careful to use CTRL+SHIFT+ENTER but it is returning a #VALUE!

I will continue to see if I can get it to work - open to suggestions ?

 

[Steve 1962]

Does it matter that the dates in colum A (rows 3 to 12) are derived from a formula ?

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1	Text
2	Text
3	01/10/2021
4	10/10/2021
5	17/10/2021
6	21/10/2021
7	01/11/2021
8	02/11/2021
9	17/11/2021
10	06/12/2021
11	21/12/2021
12	25/12/2021
13
14	Start	End
15	3	6	01/10/2021
16	7	9	01/11/2021
17	10	12	01/12/2021
18
Main

Cell Formulas
Range	Formula
A15:A17	A15	=XMATCH(MONTH(C15),MONTH($A$1:$A$12),0,1)
B15:B17	B15	=XMATCH(MONTH(C15),MONTH($A$1:$A$12),0,-1)

 

[DanteAmor]

Does it matter that the dates in colum A (rows 3 to 12) are derived from a formula ?

It doesn't matter, as long as the result is a date.
It is also important that in cells C15, C16 and C17 you have dates.

 

[Steve 1962]

Hi Dante & Fluff

Not sure what was happening on my end but I could only get it work with the XMATCH function.

Appreciate both of your help.

Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.