Date Value to Code ID

[parvezse16]

Sir, I'm looking for a formula that generates the Date ID from Date value like below in mini sheet, I found a pattern using CountIF on A1&B1 that is 1/1/1900, I don't know how to use this pattern for 05.09.21(todays date) to get a Date like in the below cells.
Thanks in advance

Date ID	Date
8913830B	25.01.21
6018EF9F	23.02.21
A38F431A	25.02.21
2A31AD47	03.03.21
D78B5B8C	10.03.21
61A94CF5	15.03.21
D94D3277	23.03.21
E32C8007	23.04.21
4710767A	03.05.21
9A86CB37	01.06.21
9A86CB37	01.06.21
B15AE204	06.05.21
09304B44	17.09.20
24C1DD4C	03.06.21
5001BBCA	06.08.21
B9D41D5A	11.08.21
65BD1019	13.08.21
02CA0744	16.08.21
BB56EE37	17.08.21
631F012D	23.08.21
631F012D	23.08.21
FB8B4C15	24.08.21
FB8B4C15	24.08.21
51B7885A	30.08.21
1DD5A3BE	16.10.20
1093B676	22.10.20
CB63F58B	27.05.21
FAF145C9	01.09.21
86BA7A29	02.09.21
73ECC05F	03.09.21
3A9F5533	21.10.20

 

[jasonb75]

the origin of creation is in invoice,

That is when and where it is created, not how.
How it was created would be the algorithm used to generate the code from the date.

 

[parvezse16]

That is when and where it is created, not how.
How it was created would be the algorithm used to generate the code from the date.

There are several parameters on each invoice, there might be an OP

 

[jasonb75]

there might be an OP

There might not as well. If you can provide all of the information then we should be able to come up with a formula that works, however I will not waste time looking for something in a screen capture that may or may not be there.

 

[parvezse16]

There might not as well. If you can provide all of the information then we should be able to come up with a formula that works, however I will not waste time looking for something in a screen capture that may or may not be there.

I'm honored to have you Sir, and I'll not waste your time.
I will share a mini-Sheet, that have each invoice parameters. May be than you could help me out.