I have occasional reports that require a unique identifying number. The format we use for this number is: the date of the report, converted to yymmdd with a non-repeating sequential 4-digit number. Below is an example:
Report generated on Feb, 1 2019 would have a number of 1902010001
Report generated on Apr, 16 2019 would have a number of 1904160002
I have created a simple spreadsheet with a column of sequential numbers. another column whereby the report date can be entered. What I am hoping for is a formula that will combine the two cells into a copy-pastable text field.
Report generated on Feb, 1 2019 would have a number of 1902010001
Report generated on Apr, 16 2019 would have a number of 1904160002
I have created a simple spreadsheet with a column of sequential numbers. another column whereby the report date can be entered. What I am hoping for is a formula that will combine the two cells into a copy-pastable text field.