redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hey all
Is there any formula or VB code that can look down the list of dates in column A and produce a dynamic list in oldest to newest order?
The required result shown in column c
Is there any formula or VB code that can look down the list of dates in column A and produce a dynamic list in oldest to newest order?
NDA.v6.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | DATE | ||||
2 | 01-Jan-20 | ||||
3 | 03-Feb-20 | January 2020 | |||
4 | 09-Feb-20 | February 2020 | |||
5 | 20-Mar-20 | March 2020 | |||
6 | 23-Mar-20 | April 2020 | |||
7 | 04-Apr-20 | January 2021 | |||
8 | 09-Apr-20 | February 2021 | |||
9 | 05-Jan-21 | September 2021 | |||
10 | 09-Feb-21 | February 2022 | |||
11 | 11-Feb-21 | ||||
12 | 17-Sep-21 | ||||
13 | 03-Feb-22 | ||||
Data (2) |
The required result shown in column c