Class Schedule Generator
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRS
1
This spreadsheet generates a list of dates and days for typical class schedules at Gustavus. To use the spreadsheet, choose the schedule (e.g., MWF or TTh) that your class follows and enter the date of your first class period in the green cell of the appropriate section (I've already done this for Spring 2013). The cells below and to the right of the green cell will automatically update themselves. You can then highlight the dates & days and copy and paste them into the software that you are using to maintain your class schedule. Next semester, return to this spreadsheet and change the date in the green cell to generate a new schedule. Hope this saves you some time.

Notes: The formulas used to generate the dates assume that if you are in the MWF section, the first date you enter is either a M, W, or F, and if you are in the TTh section, the first date is either a T or Th. If these assumptions aren't satisfied, the dates won't update properly. The spreadsheet generates more dates than you need (especially for classes that meet only twice a week). After you copy them from this spreadsheet, just delete the dates you don't need.
2
MWF ClassesTTh ClassesMW Classes
3
DateDay of WeekDate Day of WeekDateDay of Week
4
8/23/2017Wednesday9/5/2017Tuesday9/6/2017Wednesday
5
8/25/2017Friday9/7/2017Thursday9/11/2017Monday
6
8/28/2017Monday9/12/2017Tuesday9/13/2017Wednesday
7
8/30/2017Wednesday9/14/2017Thursday9/18/2017Monday
8
9/1/2017Friday9/19/2017Tuesday9/20/2017Wednesday
9
9/4/2017Monday9/21/2017Thursday9/25/2017Monday
10
9/6/2017Wednesday9/26/2017Tuesday9/27/2017Wednesday
11
9/8/2017Friday9/28/2017Thursday10/2/2017Monday
12
9/11/2017Monday10/3/2017Tuesday10/4/2017Wednesday
13
9/13/2017Wednesday10/5/2017Thursday10/9/2017Monday
14
9/15/2017Friday10/10/2017Tuesday10/11/2017Wednesday
15
9/18/2017Monday10/12/2017Thursday10/16/2017Monday
16
9/20/2017Wednesday10/17/2017Tuesday10/18/2017Wednesday
17
9/22/2017Friday10/19/2017Thursday10/23/2017Monday
18
9/25/2017Monday10/24/2017Tuesday10/25/2017Wednesday
19
9/27/2017Wednesday10/26/2017Thursday10/30/2017Monday
20
9/29/2017Friday10/31/2017Tuesday11/1/2017Wednesday
21
10/2/2017Monday11/2/2017Thursday11/6/2017Monday
22
10/4/2017Wednesday11/7/2017Tuesday11/8/2017Wednesday
23
10/6/2017Friday11/9/2017Thursday11/13/2017Monday
24
10/9/2017Monday11/14/2017Tuesday11/15/2017Wednesday
25
10/11/2017Wednesday11/16/2017Thursday11/20/2017Monday
26
10/13/2017Friday11/21/2017Tuesday11/22/2017Wednesday
27
10/16/2017Monday11/23/2017Thursday11/27/2017Monday
28
10/18/2017Wednesday11/28/2017Tuesday11/29/2017Wednesday
29
10/20/2017Friday11/30/2017Thursday12/4/2017Monday
30
10/23/2017Monday12/5/2017Tuesday12/6/2017Wednesday
31
10/25/2017Wednesday12/7/2017Thursday12/11/2017Monday
32
10/27/2017Friday12/12/2017Tuesday12/13/2017Wednesday
33
10/30/2017Monday12/14/2017Thursday12/18/2017Monday
34
11/1/2017Wednesday12/19/2017Tuesday12/20/2017Wednesday
35
11/3/2017Friday12/21/2017Thursday12/25/2017Monday
36
11/6/2017Monday12/26/2017Tuesday12/27/2017Wednesday
37
11/8/2017Wednesday12/28/2017Thursday1/1/2018Monday
38
11/10/2017Friday1/2/2018Tuesday1/3/2018Wednesday
39
11/13/2017Monday1/4/2018Thursday1/8/2018Monday
40
11/15/2017Wednesday1/9/2018Tuesday1/10/2018Wednesday
41
11/17/2017Friday1/11/2018Thursday1/15/2018Monday
42
11/20/2017Monday1/16/2018Tuesday1/17/2018Wednesday
43
11/22/2017Wednesday1/18/2018Thursday1/22/2018Monday
44
11/24/2017Friday1/23/2018Tuesday1/24/2018Wednesday
45
11/27/2017Monday1/25/2018Thursday1/29/2018Monday
46
11/29/2017Wednesday1/30/2018Tuesday1/31/2018Wednesday
47
12/1/2017Friday2/1/2018Thursday2/5/2018Monday
48
12/4/2017Monday2/6/2018Tuesday2/7/2018Wednesday
49
12/6/2017Wednesday2/8/2018Thursday2/12/2018Monday
50
12/8/2017Friday2/13/2018Tuesday2/14/2018Wednesday
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
Loading...
 
 
 
Class Dates