Date Value to Code ID

parvezse16

New Member
Joined
Sep 5, 2021
Messages
14
Office Version
  1. 2013
Platform
  1. Windows
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 IDDate
8913830B25.01.21
6018EF9F23.02.21
A38F431A25.02.21
2A31AD4703.03.21
D78B5B8C10.03.21
61A94CF515.03.21
D94D327723.03.21
E32C800723.04.21
4710767A03.05.21
9A86CB3701.06.21
9A86CB3701.06.21
B15AE20406.05.21
09304B4417.09.20
24C1DD4C03.06.21
5001BBCA06.08.21
B9D41D5A11.08.21
65BD101913.08.21
02CA074416.08.21
BB56EE3717.08.21
631F012D23.08.21
631F012D23.08.21
FB8B4C1524.08.21
FB8B4C1524.08.21
51B7885A30.08.21
1DD5A3BE16.10.20
1093B67622.10.20
CB63F58B27.05.21
FAF145C901.09.21
86BA7A2902.09.21
73ECC05F03.09.21
3A9F553321.10.20
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,730
Messages
6,192,703
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top