Google Sheets Leave Tracker

	A	GF	GG	GH	GI	GJ	GK	GL	GM	GN	GO	GP	GQ	GR	GS	GT	GU	GV	GW	GX	GY	GZ	HA	HB	HC	HD	HE	HF	HG	HH	HI	NK	NL	NM	NN	NO	NP	NQ	NR	NS	NT	NU	NW	NX	NZ	OA
1	5
2	2022																																			November 2022
3
4																																	Leave Breakup
5		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	Leaves This Year	S	V	M	P	C	Co	W	O	H1	H2
6	Name	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Leaves This Year	S	V	M	P	C	Co	W	O	H1	H2	Leave Name	Code

8	Employee 1																															0											Sick Leave	S	Holiday	Date
9	Employee 2																															0											Vacation	V	New Year Day	01 Jan, 2019
10	Employee 3																															0											Maternity Leave	M	Martin Luther King Junior Day	21 Jan, 2019
11	Employee 4																															0											Paternity Leave	P	President's Day	18 Feb, 2019
12	Employee 5																															0											Casual Leave	C	Easter	21 Apr, 2019
13	Employee 6																															0											Compassionate	Co	Memorial Day	27 May, 2019
14	Employee 7																															0											Work from Home	W	Independence Day	04 Jul, 2019
15	Employee 8																															0											Comp OFF	O	Labor Day	02 Sep, 2019
16	Employee 9																															0											Half Day Leave 1	H1	Columbus Day	14 Oct, 2019
17	Employee 10																															0											Half Day Leave 2	H2	Veterans Day	11 Nov, 2019
18	Employee 11																															0													Thanksgiving Day	28 Nov, 2019
19	Employee 12																															0													Christmas Day	25 Dec, 2019
20	Employee 13																															0											Select Working Days
21	Employee 14																															0											Mon	Yes
22	Employee 15																															0											Tue	Yes
23	Employee 16																															0											Wed	Yes
24	Employee 17																															0											Thu	Yes
25	Employee 18																															0											Fri	Yes
26	Employee 19																															0											Sat	No
27	Employee 20																															0											Sun	No
28	Employee 21																															0
29	Employee 22																															0
30	Employee 23																															0
31	Employee 24																															0
32	Employee 25																															0
33	Employee 26																															0
34	Employee 27																															0
35	Employee 28																															0
36	Employee 29																															0
37	Employee 30																															0
38	Employee 31																															0
39	Employee 32																															0
40	Employee 33																															0
41	Employee 34																															0
42	Employee 35																															0
43	Employee 36																															0
44	Employee 37																															0
45	Employee 38																															0
46	Employee 39																															0
47	Employee 40																															0
48	Employee 41																															0
49	Employee 42																															0
50	Employee 43																															0
51	Employee 44																															0
52	Employee 45																															0
53	Employee 46																															0
54	Employee 47																															0
55	Employee 48																															0
56	Employee 49																															0
57	Employee 50																															0
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
101