Job Number Sequence

[girloffbeat]

Hoping someone can help me with this. We have a job number system that I manually have to enter and I was hoping there is a way to automate the date, year, and number? Does this make sense?
Our job numbering system is as follows:

Month	Year	Number		Job Number	Name	Address
10	22	536		1022-536	Jon Doe	123 Main Street
10	22	537		1022-537	Jon Doe	124 Main Street
10	22	538		1022-538	Jon Doe	125 Main Street
11	22	539		1122-539	Jon Doe	126 Main Street
11	22	540		1122-540	Jon Doe	127 Main Street
11	22	541		1122-541	Jon Doe	128 Main Street
11	22	542		1122-542	Jon Doe	129 Main Street
11	22	543		1122-543	Jon Doe	130 Main Street

 

[JoeMo]

Welcome to the forum.
Maybe something like this where you enter a seed number in C2. After that you enter only name and address and the Month, Year, Number and Job Number are returned by formulas.

Book1
	A	B	C	D	E	F	G	H	I
1	Month	Year	Number		Job Number	Name	Address
2	11	22	536		1122-536	Jon Doe	123 Main Street		<-- seed Number
3	11	22	537		1122-537	Jon Doe	124 Main Street
4
5
6
7
8
9
10
Sheet1

Cell Formulas
Range	Formula
A2:A10	A2	=IF(F2="","",MONTH(TODAY()))
B2:B10	B2	=IF(F2="","",RIGHT(YEAR(TODAY()),2)+0)
C3:C10	C3	=IF(F3="","",C2+1)
E2:E10	E2	=IF(F2="","",A2&B2&"-"&C2)