Sorting the dates from beginning to end with a formula

[asyamonique]

Hello,
Please help me with the question below samle.
I need a formula which will show me the dates from start to end between two related dates from two cells.
On my worksheet column M and Column N has the date ranges all the way downwhich randomly.I need to sort those dates one by one.
Is it possible with a formula?
Many Thanks

COLUMN M	COLUMN N		COLUMN T	COLUMN U	COLUMN V	COLUMN W	COLUMN X	COLUMN Y
14-Mar-2019	21-Mar-2019		14-Mar-2019	15-Mar-2019	16-Mar-2019	17-Mar-2019	18-Mar-2019	19-Mar-2019

<colgroup><col span="9"></colgroup><tbody>
</tbody>

 

[James006]

Hello,

Indeed, Excel can sort with a formula ...

However, if you are using a formula, the output range has to be different and separate from the input range ...

HTH

 

[asyamonique]

Fixed by code.
Thanks

    Range("M2:M5000").Select    Selection.Copy
    Range("T2").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    Selection.AutoFill Destination:=Range("T2:AC5000"), Type:=xlFillDays
    Range("T2:AC5000").Select
    Range("T1").Select

 

[James006]

You are welcome ...