Class Schedule Generator
 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
2/12/2018Monday2/13/2018Tuesday2/12/2018Monday
5
2/14/2018Wednesday2/15/2018Thursday2/14/2018Wednesday
6
2/16/2018Friday2/20/2018Tuesday2/19/2018Monday
7
2/19/2018Monday2/22/2018Thursday2/21/2018Wednesday
8
2/21/2018Wednesday2/27/2018Tuesday2/26/2018Monday
9
2/23/2018Friday3/1/2018Thursday2/28/2018Wednesday
10
2/26/2018Monday3/6/2018Tuesday3/5/2018Monday
11
2/28/2018Wednesday3/8/2018Thursday3/7/2018Wednesday
12
3/2/2018Friday3/13/2018Tuesday3/12/2018Monday
13
3/5/2018Monday3/15/2018Thursday3/14/2018Wednesday
14
3/7/2018Wednesday3/20/2018Tuesday3/19/2018Monday
15
3/9/2018Friday3/22/2018Thursday3/21/2018Wednesday
16
3/12/2018Monday3/27/2018Tuesday3/26/2018Monday
17
3/14/2018Wednesday3/29/2018Thursday3/28/2018Wednesday
18
3/16/2018Friday4/3/2018Tuesday4/2/2018Monday
19
3/19/2018Monday4/5/2018Thursday4/4/2018Wednesday
20
3/21/2018Wednesday4/10/2018Tuesday4/9/2018Monday
21
3/23/2018Friday4/12/2018Thursday4/11/2018Wednesday
22
3/26/2018Monday4/17/2018Tuesday4/16/2018Monday
23
3/28/2018Wednesday4/19/2018Thursday4/18/2018Wednesday
24
3/30/2018Friday4/24/2018Tuesday4/23/2018Monday
25
4/2/2018Monday4/26/2018Thursday4/25/2018Wednesday
26
4/4/2018Wednesday5/1/2018Tuesday4/30/2018Monday
27
4/6/2018Friday5/3/2018Thursday5/2/2018Wednesday
28
4/9/2018Monday5/8/2018Tuesday5/7/2018Monday
29
4/11/2018Wednesday5/10/2018Thursday5/9/2018Wednesday
30
4/13/2018Friday5/15/2018Tuesday5/14/2018Monday
31
4/16/2018Monday5/17/2018Thursday5/16/2018Wednesday
32
4/18/2018Wednesday5/22/2018Tuesday5/21/2018Monday
33
4/20/2018Friday5/24/2018Thursday5/23/2018Wednesday
34
4/23/2018Monday5/29/2018Tuesday5/28/2018Monday
35
4/25/2018Wednesday5/31/2018Thursday5/30/2018Wednesday
36
4/27/2018Friday6/5/2018Tuesday6/4/2018Monday
37
4/30/2018Monday6/7/2018Thursday6/6/2018Wednesday
38
5/2/2018Wednesday6/12/2018Tuesday6/11/2018Monday
39
5/4/2018Friday6/14/2018Thursday6/13/2018Wednesday
40
5/7/2018Monday6/19/2018Tuesday6/18/2018Monday
41
5/9/2018Wednesday6/21/2018Thursday6/20/2018Wednesday
42
5/11/2018Friday6/26/2018Tuesday6/25/2018Monday
43
5/14/2018Monday6/28/2018Thursday6/27/2018Wednesday
44
5/16/2018Wednesday7/3/2018Tuesday7/2/2018Monday
45
5/18/2018Friday7/5/2018Thursday7/4/2018Wednesday
46
5/21/2018Monday7/10/2018Tuesday7/9/2018Monday
47
5/23/2018Wednesday7/12/2018Thursday7/11/2018Wednesday
48
5/25/2018Friday7/17/2018Tuesday7/16/2018Monday
49
5/28/2018Monday7/19/2018Thursday7/18/2018Wednesday
50
5/30/2018Wednesday7/24/2018Tuesday7/23/2018Monday
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
 
 
Main menu