Using Row function i need to find out all the dates

[CA_Punit]

Hi,

I need to find dates between 01/07/2020 to 10/07/2020 including both the dates (Like an array spill) using Row Function
@Eric W has used it somewhere i am not able to find the post where he has just selected the two dates in row function

Currently i am using this.

S7_BuiltinFunctions_Start.xlsx
	J	K	L
12	10/07/2020		10/07/2020
13	11/07/2020		24/07/2020
14	12/07/2020
15	13/07/2020
16	14/07/2020
17	15/07/2020
18	16/07/2020
19	17/07/2020
20	18/07/2020
21	19/07/2020
22	20/07/2020
23	21/07/2020
24	22/07/2020
25	23/07/2020
26	24/07/2020
Sheet1

Cell Formulas
Range	Formula
J12:J26	J12	=(ROW(INDIRECT("A1:A"&$L$13-$L$12+1)))-ROW($A$1)+L12
Dynamic array formulas.

Is there any simple way

 

[Fluff]

I would use Sequence

+Fluff New.xlsm
	K	L	M	N
1
2		10/07/2020		10/07/2020
3		11/07/2020		24/07/2020
4		12/07/2020
5		13/07/2020
6		14/07/2020
7		15/07/2020
8		16/07/2020
9		17/07/2020
10		18/07/2020
11		19/07/2020
12		20/07/2020
13		21/07/2020
14		22/07/2020
15		23/07/2020
16		24/07/2020
17
Main

Cell Formulas
Range	Formula
L2:L16	L2	=SEQUENCE(N3-N2+1,,N2)
Dynamic array formulas.

 

[Fluff]

If you want to use a volatile function then try
=ROW(INDIRECT("A"&N2):INDIRECT("A"&N3))

 

[CA_Punit]

Yes Sequence is great,
and i suppose @Eric W had used =ROW(INDIRECT("A"&N2):INDIRECT("A"&N3))

And thanks @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Eric W]

You can get rid of one of the INDIRECTs like this:

=ROW(INDIRECT(N2&":"&N3))

You don't need the preceding A either. However, if you have the new SEQUENCE function (I still don't!), that's definitely a better choice.

 

[CA_Punit]

This is what i was searching for. Now i have 3 tricks

Thanks