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.

[TABLE="width: 181"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Date Order[/TD]
[/TR]
[TR]
[TD]10/20/2019[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]10/20/2019[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]10/18/2019[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]10/18/2019[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]10/17/2019[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10/17/2019[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10/17/2019[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10/17/2019[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10/17/2019[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10/17/2019[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10/17/2019[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10/17/2019[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10/16/2019[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10/16/2019[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10/19/2019[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]10/20/2019[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

 

[rpaulson]

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

fill down as needed

 

[lager1001]

Worked great. Thank you!