Gantt Chart Template for Google Sheets

	A	B	C	D	E	F	G	H	I	J	P	U	Z	AE
1	#REF!
2
3	GANTT CHART TEMPLATE				Build better gantt charts with TeamGantt for FREE!
4
5	To edit this chart, you must first make a copy. Go to File, the select Make a Copy.
6	* = an automatically calculated cell
7		TASK NAME	START DATE	DAY OF MONTH*	END DATE	DURATION* (WORK DAYS)	DAYS COMPLETE*	DAYS REMAINING*	TEAM MEMBER	PERCENT COMPLETE	WEEK 1	WEEK 2	WEEK 3	WEEK 4
8		TASK NAME	START DATE	DAY OF MONTH*	END DATE	DURATION* (WORK DAYS)	DAYS COMPLETE*	DAYS REMAINING*	TEAM MEMBER	PERCENT COMPLETE
9	First Sample Project
10		Write Landing Page Copy	1/5	5	1/8	3	3	0	Nathan	100%
11		Approve Page Copy	1/8	8	1/11	3	2.4	0.6	Meredith	80%
12		Review Landing Page Design	1/11	11	1/16	5	3	2	Brandon	60%
13		Build Landing Page	1/14	14	1/19	5	2	3	Michael	40%
14		Code Review Landing Page	1/17	17	1/23	6	1.2	4.8	Rachel	20%
15	Second Sample Project
16		Write Promotional Email	1/9	9	1/12	3	3	0	Nathan	100%
17		Design Promotional Email	1/12	12	1/19	7	5.6	1.4	Meredith	80%
18		Send Promotional Email	1/17	17	1/19	2	1.2	0.8	Brandon	60%
19		Analyze Campaign Results	1/22	22	1/26	4	1.6	2.4	Michael	40%
20	Third Sample Project
21		Plan Agenda for Meeting	1/15	15	1/19	4	4	0	Nathan	100%
22		Reserve Room	1/22	22	1/23	1	0.8	0.2	Meredith	80%
23		Finalize Presentation	1/22	22	1/26	4	2.4	1.6	Brandon	60%
24		Approve Presentation	1/26	26	1/29	3	1.2	1.8	Michael	40%
25		Create Invitations	1/22	22	1/25	3	0.6	2.4	Rachel	20%
26	Fourth Sample Project
27		Rewrite Online Calculator	1/15	15	1/24	9	9	0	Nathan	100%
28		Code Review Calculator	1/25	25	1/30	5	4	1	Meredith	80%
29		Update Messaging	1/24	24	1/30	6	3.6	2.4	Michael	60%
30		Publish Calculator	1/30	30	1/31	1	0	1	Rachel	0%
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