Employee absence schedule.xlsx

	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	AH
1	Employee absence schedule
2	January
3
4	Absence type key	A	Attend			L	Leave			S	Sick		P	Part Day			W	Weekend/Public				H	WFH
5
6		Dates of absence																															2023
7		aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa	aaa
8	Employee name	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Total days
9	Harsimran Brar			V	V	V	V			H	H			A	W	W	W																10
10	Jordan Mitchell					S	S					P									S					V	V	V					7
11	Asaf Karten			P											S															S			3
12	Vanja Jovanovic							P												V	V	V											4
13	Madison Butler				S	V	V											S							S							V	6
14	January total			2	2	3	3	1		1	1	1		1	2	1	1	1		1	2	1			1	1	1	1		1		1	#ERROR!
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100