Job number generator for dispatch excel sheet

[jsink1980]

I am curious if anyone could help me.

I am looking to add a job number cell on my company dispatch sheet. Is it possible to have an auto generating job number cell that includes a 3 letter prefix for company name plus date and job number?

An example would be like this..... 19-ABC-05-001 (year-company-month-job number)

I am really hoping its possible.

Any help is appreciated!!

 

[Fluff]

Hi & welcome to MrExcel.
How about

Excel 2013/2016
	A	B	C
2	abc	001	19-abc-05-001
Dates

Cell Formulas
Range	Formula
C2	=TEXT(TODAY(),"yy")&"-"&A2&"-"&TEXT(TODAY(),"mm")&"-"&B2

 

[jsink1980]

Oh that is awesome! Thanks for the quick reply!

 

[Fluff]

You're welcome & thanks for the feedback