I have a column with hundreds of dates. The dates are always the most current 5 sequential dates so they change daily. I need a helper column that will tell me which date is 1, which date is 2, which date is 3, which date is 4, and which date is 5 in order of occurrence.
<colgroup><col><col></colgroup><tbody>
</tbody>
Date | Date Order |
10/20/2019 | 5 |
10/20/2019 | 5 |
10/18/2019 | 3 |
10/18/2019 | 3 |
10/17/2019 | 2 |
10/17/2019 | 2 |
10/17/2019 | 2 |
10/17/2019 | 2 |
10/17/2019 | 2 |
10/17/2019 | 2 |
10/17/2019 | 2 |
10/17/2019 | 2 |
10/16/2019 | 1 |
10/16/2019 | 1 |
10/19/2019 | 4 |
10/20/2019 | 5 |
<colgroup><col><col></colgroup><tbody>
</tbody>