Assign each day a number

[jmcdonald22]

I have a list of invoice dates between two periods for a total of 260 business days. I need to find a way to assign a number between 1-260 to each invoice date. I have other fields being pulled in that is duplicating my invoice date preventing me from sorting and numbering 1-260. I hope my explanation makes sense and thank you for the help.

 

[Lord Excelsius]

Squire,

Does your data set include invoice numbers? If so, sort on invoice date then on invoice number. Once that is complete you could easily assign your own numbers/codes as needed.

 

[jmcdonald22]

I don't have invoice numbers but the fields I do have allowed me to sort and number. I just wasn't able to see it first go around. Thanks for the help!

 

[Lord Excelsius]

On second thought, I think I misread your question.

You could copy/paste the invoice date column into another worksheet, then remove all duplicates so you are left with only a single line item for each date. Then sort the dates, and assign numbers 1-260.

After that, you can vlookup or index/match the assigned numbers to the dates in your primary data set.

 

[jmcdonald22]

That would work too. Thanks!