get dates from a range in ascending order

[dino4u86]

On another sheet, I have dates in column A. In the new sheet, I need to first extract the earliest date from column A of that other sheet which is easy. just use the "Min" function for A column. So now the earliest date get picked and feeds into the cell of the new sheet in D1. How do I get the next earliest date after D1 from the range Column A of the other sheet and input that in D2. Basically picking the dates and sorting the dates in a ascending ordering through a formula is what I need. Thanks

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1
2	15/03/2021			16/01/2021
3	15/09/2021			22/01/2021
4	29/03/2021			29/01/2021
5	09/06/2021			06/03/2021
6	27/07/2021			15/03/2021
7	06/03/2021			23/03/2021
8	29/01/2021			29/03/2021
9	12/08/2021			04/04/2021
10	27/07/2021			15/04/2021
11	04/04/2021			07/06/2021
12	04/10/2021			09/06/2021
13	16/01/2021			07/07/2021
14	07/06/2021			27/07/2021
15	15/04/2021			27/07/2021
16	18/10/2021			04/08/2021
17	22/01/2021			12/08/2021
18	07/07/2021			15/09/2021
19	04/08/2021			04/10/2021
20	15/10/2021			15/10/2021
21	23/03/2021			18/10/2021
22
Sheet1

Cell Formulas
Range	Formula
D2:D21	D2	=AGGREGATE(15,6,$A$2:$A$21,ROWS(D$2:D2))

 

[dino4u86]

Thank for the help but this does not ignore the duplicate dates. sorry I should have mentioned earlier. Can you help with that?

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	A	B	C	D
1
2	15/03/2021			16/01/2021
3	15/09/2021			22/01/2021
4	29/03/2021			29/01/2021
5	09/06/2021			06/03/2021
6	27/07/2021			15/03/2021
7	06/03/2021			23/03/2021
8	29/01/2021			29/03/2021
9	12/08/2021			04/04/2021
10	27/07/2021			15/04/2021
11	04/04/2021			07/06/2021
12	04/10/2021			09/06/2021
13	16/01/2021			07/07/2021
14	07/06/2021			27/07/2021
15	15/04/2021			04/08/2021
16	18/10/2021			12/08/2021
17	22/01/2021			15/09/2021
18	07/07/2021			04/10/2021
19	04/08/2021			15/10/2021
20	15/10/2021			18/10/2021
21	23/03/2021
22
Sheet1

Cell Formulas
Range	Formula
D2:D21	D2	=IFERROR(AGGREGATE(15,6,$A$2:$A$21/(COUNTIFS(D$1:D1,$A$2:$A$21)=0),1),"")

 

[dino4u86]

Thanks a lot. Though this work I'm unable to update the cells by dragging the formulas down. I need to hit enter on every cell and it updates the cell with the result as expected. why is that?

 

[dino4u86]

Thanks a lot. Though this work I'm unable to update the cells by dragging the formulas down. I need to hit enter on every cell and it updates the cell with the result as expected. why is that?

Problem solved. thanks a lot for all your help

 

[Fluff]

You're welcome & thanks for the feedback.