Month schedule

[rakrimes]

I want to make a staff schedule using a monthly template as in 1-31 sun-sat and have it track hours worked as well.

Any help would be appreciated as I am not to savvy with excel

 

[Oscar Cronquist]

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​	R​	S​	T​	U​	V​	W​	X​	Y​	Z​	AA​	AB​	AC​	AD​	AE​	AF​	AG​
1​		Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We
2​	Name	01​	02​	03​	04​	05​	06​	07​	08​	09​	10​	11​	12​	13​	14​	15​	16​	17​	18​	19​	20​	21​	22​	23​	24​	25​	26​	27​	28​	29​	30​	31​	Sum:
3​	John		8​		8​						8​		8​																				32​
4​	Jennifer			9​								8​				9​				8​													34​
5​
6​
7​
8​
9​
10​
11​	Date	1/1/2018

Sheet: Sheet39

Formula in cell B2:
=B11

Formula in cell C2:
=B2+1

Copy cell C2 and paste to cell range D2:AF2.

Formula in cell AG3:
=SUM(B3:AF3)

Copy cell AG3 and paste cells below as far as needed.

Date in cell B11 determines the schedule month.