Extracting a date

[RID]

Good Morning

Is it possible to use a formula to extract a date from automated assigned ID. For instance our software for reporting incidents produces an ID number which is in the form of text and numbers AC-INC-20180511-005 for example. The date is the number 8 figure number within this produced number in YYYYMMDD format, is there a formula that can be used to extract this number into another cell without having to manually input?

regards

Neil

 

[steve the fish]

See if this helps.

=0+TEXT(MID(A1,FIND("-20",A1)+1,8),"00\/00\/00")

 

[RID]

Steve you are a legend thank you very much worked perfect

 

[Rick Rothstein]

If your ID numbers always consist of 2 characters, a dash, 3 more characters, another dash and then the 8-digit date value, then you can use this formula to retrieve the date...

=0+TEXT(MID(A1,8,8),"0000-00-00")

This returns the date serial number so you will need to then format the cell you put this formula in with the date format of your choosing.