Need Order of Date Range Indicated Numerically eg. (1-5)

[lager1001]

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.

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>

 

[rpaulson]

try this:
=A1-MAX($A$1:$A$16) +5

fill down as needed

 

[lager1001]

Worked great. Thank you!