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

lager1001

Board Regular
Joined
May 17, 2019
Messages
50
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.

DateDate Order
10/20/20195
10/20/20195
10/18/20193
10/18/20193
10/17/20192
10/17/20192
10/17/20192
10/17/20192
10/17/20192
10/17/20192
10/17/20192
10/17/20192
10/16/20191
10/16/20191
10/19/20194
10/20/20195

<colgroup><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,099,568
Messages
5,469,457
Members
406,653
Latest member
CBeeker

This Week's Hot Topics

Top