How to label and rank various weeks by oldest to newest

[jarrazolo2]

Hello,

I will be feeding the workflow new data each week so i need the formula to be dynamic.

I have a data set that has a week of column. I would like to find a way to create a new column called 'Week #' that ranks the weeks by oldest to newest. can anyone help please?

Record	Week Of	Week #
1	29-May	1
2	22-May	2
3	15-May	3
4	8-May	4

[smoosh]

Sorting will do what you need. biggest trick for you will be getting the date values into the proper format. See attached as an example. 

[Dina]

Once the you covert the Week of to a date, you should be able to sort the way you like. 

[geraldo]

@jarrazolo2 

a couple example every year