Assigning Dates a Value in the ascending order

[Kirtana]

Hello - I have a column which has 4 or 5 dates in it (these dates will change every time). I need to add a column which tags the first (earliest) date as 1, the second (next) as 2 and so on. 

Appreciate your help!

Thank you 🙂

[wwatson]

Try something like this:

[Kirtana]

Oh thank you! I actually forgot to mention that the dates would be repetitive. 

Eg: 50 rows with the 3 dates below:

2nd Apr

5th Apr

6th Apr

I would need everything under 1st April as 1, All lines under 5th April as 2 and so on! More like a grouping! 

Is that possible?

[wwatson]

you would have to define how you want the grouping to work, but i am sure it can be done in the formula.

[wwatson · Accepted solution]

here is another option to cope with repeating dates:

[Kirtana]

This worked! Thank you 🙂