unique Code

[noubaba]

I need help to design a formula in excel to develop a unique random code, for example I have "Received" word in A1 cell then I want to get a unique Code in B1 cell, code should capture “R” from A1 cell then contain today’s current date like 011019 (01 day, 10 month, 19 year) then capture any random numerical digits to make this code unique. I have thousands of entries, code in B1 against A1 must not be duplicated with all above codes in B1 column. Finally code should be looked like R01101932 or R011019543 (last numeric digits 32 and 543 will be random digits captured by formula to make each codes unique). Excel experts please help, Thank you.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1111146-unique-code-post5349533.html#post5349533

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).