Adventure Works.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	ID	Date	DayNumberOfWeek	DayName	DayNumberOfMonth	DayNumberOfYear	WeekNumberOfYear	MonthName	MonthNumberOfYear	CalendarQuarter	CalendarYear	FiscalQuarter	FiscalYear	FiscalSemester	Period
2	1	7/1/2001	1	Sunday	1	182	27	July	7	3	2001	1	2002	1	200107
3	2	7/2/2001	2	Monday	2	183	27	July	7	3	2001	1	2002	1	200107
4	3	7/3/2001	3	Tuesday	3	184	27	July	7	3	2001	1	2002	1	200107
5	4	7/4/2001	4	Wednesday	4	185	27	July	7	3	2001	1	2002	1	200107
6	5	7/5/2001	5	Thursday	5	186	27	July	7	3	2001	1	2002	1	200107
7	6	7/6/2001	6	Friday	6	187	27	July	7	3	2001	1	2002	1	200107
8	7	7/7/2001	7	Saturday	7	188	27	July	7	3	2001	1	2002	1	200107
9	8	7/8/2001	1	Sunday	8	189	28	July	7	3	2001	1	2002	1	200107
10	9	7/9/2001	2	Monday	9	190	28	July	7	3	2001	1	2002	1	200107
11	10	7/10/2001	3	Tuesday	10	191	28	July	7	3	2001	1	2002	1	200107
12	11	7/11/2001	4	Wednesday	11	192	28	July	7	3	2001	1	2002	1	200107
13	12	7/12/2001	5	Thursday	12	193	28	July	7	3	2001	1	2002	1	200107
14	13	7/13/2001	6	Friday	13	194	28	July	7	3	2001	1	2002	1	200107
15	14	7/14/2001	7	Saturday	14	195	28	July	7	3	2001	1	2002	1	200107
16	15	7/15/2001	1	Sunday	15	196	29	July	7	3	2001	1	2002	1	200107
17	16	7/16/2001	2	Monday	16	197	29	July	7	3	2001	1	2002	1	200107
18	17	7/17/2001	3	Tuesday	17	198	29	July	7	3	2001	1	2002	1	200107
19	18	7/18/2001	4	Wednesday	18	199	29	July	7	3	2001	1	2002	1	200107
20	19	7/19/2001	5	Thursday	19	200	29	July	7	3	2001	1	2002	1	200107
21	20	7/20/2001	6	Friday	20	201	29	July	7	3	2001	1	2002	1	200107
22	21	7/21/2001	7	Saturday	21	202	29	July	7	3	2001	1	2002	1	200107
23	22	7/22/2001	1	Sunday	22	203	30	July	7	3	2001	1	2002	1	200107
24	23	7/23/2001	2	Monday	23	204	30	July	7	3	2001	1	2002	1	200107
25	24	7/24/2001	3	Tuesday	24	205	30	July	7	3	2001	1	2002	1	200107
26	25	7/25/2001	4	Wednesday	25	206	30	July	7	3	2001	1	2002	1	200107
27	26	7/26/2001	5	Thursday	26	207	30	July	7	3	2001	1	2002	1	200107
28	27	7/27/2001	6	Friday	27	208	30	July	7	3	2001	1	2002	1	200107
29	28	7/28/2001	7	Saturday	28	209	30	July	7	3	2001	1	2002	1	200107
30	29	7/29/2001	1	Sunday	29	210	31	July	7	3	2001	1	2002	1	200107
31	30	7/30/2001	2	Monday	30	211	31	July	7	3	2001	1	2002	1	200107
32	31	7/31/2001	3	Tuesday	31	212	31	July	7	3	2001	1	2002	1	200107
33	32	8/1/2001	4	Wednesday	1	213	31	August	8	3	2001	1	2002	1	200108
34	33	8/2/2001	5	Thursday	2	214	31	August	8	3	2001	1	2002	1	200108
35	34	8/3/2001	6	Friday	3	215	31	August	8	3	2001	1	2002	1	200108
36	35	8/4/2001	7	Saturday	4	216	31	August	8	3	2001	1	2002	1	200108
37	36	8/5/2001	1	Sunday	5	217	32	August	8	3	2001	1	2002	1	200108
38	37	8/6/2001	2	Monday	6	218	32	August	8	3	2001	1	2002	1	200108
39	38	8/7/2001	3	Tuesday	7	219	32	August	8	3	2001	1	2002	1	200108
40	39	8/8/2001	4	Wednesday	8	220	32	August	8	3	2001	1	2002	1	200108
41	40	8/9/2001	5	Thursday	9	221	32	August	8	3	2001	1	2002	1	200108
42	41	8/10/2001	6	Friday	10	222	32	August	8	3	2001	1	2002	1	200108
43	42	8/11/2001	7	Saturday	11	223	32	August	8	3	2001	1	2002	1	200108
44	43	8/12/2001	1	Sunday	12	224	33	August	8	3	2001	1	2002	1	200108
45	44	8/13/2001	2	Monday	13	225	33	August	8	3	2001	1	2002	1	200108
46	45	8/14/2001	3	Tuesday	14	226	33	August	8	3	2001	1	2002	1	200108
47	46	8/15/2001	4	Wednesday	15	227	33	August	8	3	2001	1	2002	1	200108
48	47	8/16/2001	5	Thursday	16	228	33	August	8	3	2001	1	2002	1	200108
49	48	8/17/2001	6	Friday	17	229	33	August	8	3	2001	1	2002	1	200108
50	49	8/18/2001	7	Saturday	18	230	33	August	8	3	2001	1	2002	1	200108
51	50	8/19/2001	1	Sunday	19	231	34	August	8	3	2001	1	2002	1	200108
52	51	8/20/2001	2	Monday	20	232	34	August	8	3	2001	1	2002	1	200108
53	52	8/21/2001	3	Tuesday	21	233	34	August	8	3	2001	1	2002	1	200108
54	53	8/22/2001	4	Wednesday	22	234	34	August	8	3	2001	1	2002	1	200108
55	54	8/23/2001	5	Thursday	23	235	34	August	8	3	2001	1	2002	1	200108
56	55	8/24/2001	6	Friday	24	236	34	August	8	3	2001	1	2002	1	200108
57	56	8/25/2001	7	Saturday	25	237	34	August	8	3	2001	1	2002	1	200108
58	57	8/26/2001	1	Sunday	26	238	35	August	8	3	2001	1	2002	1	200108
59	58	8/27/2001	2	Monday	27	239	35	August	8	3	2001	1	2002	1	200108
60	59	8/28/2001	3	Tuesday	28	240	35	August	8	3	2001	1	2002	1	200108
61	60	8/29/2001	4	Wednesday	29	241	35	August	8	3	2001	1	2002	1	200108
62	61	8/30/2001	5	Thursday	30	242	35	August	8	3	2001	1	2002	1	200108
63	62	8/31/2001	6	Friday	31	243	35	August	8	3	2001	1	2002	1	200108
64	628	3/20/2003	5	Thursday	20	79	12	March	3	1	2003	3	2003	2	200303
65	629	3/21/2003	6	Friday	21	80	12	March	3	1	2003	3	2003	2	200303
66	630	3/22/2003	7	Saturday	22	81	12	March	3	1	2003	3	2003	2	200303
67	631	3/23/2003	1	Sunday	23	82	13	March	3	1	2003	3	2003	2	200303
68	632	3/24/2003	2	Monday	24	83	13	March	3	1	2003	3	2003	2	200303
69	633	3/25/2003	3	Tuesday	25	84	13	March	3	1	2003	3	2003	2	200303
70	634	3/26/2003	4	Wednesday	26	85	13	March	3	1	2003	3	2003	2	200303
71	635	3/27/2003	5	Thursday	27	86	13	March	3	1	2003	3	2003	2	200303
72	636	3/28/2003	6	Friday	28	87	13	March	3	1	2003	3	2003	2	200303
73	637	3/29/2003	7	Saturday	29	88	13	March	3	1	2003	3	2003	2	200303
74	638	3/30/2003	1	Sunday	30	89	14	March	3	1	2003	3	2003	2	200303
75	639	3/31/2003	2	Monday	31	90	14	March	3	1	2003	3	2003	2	200303
76	640	4/1/2003	3	Tuesday	1	91	14	April	4	2	2003	4	2003	2	200304
77	641	4/2/2003	4	Wednesday	2	92	14	April	4	2	2003	4	2003	2	200304
78	642	4/3/2003	5	Thursday	3	93	14	April	4	2	2003	4	2003	2	200304
79	643	4/4/2003	6	Friday	4	94	14	April	4	2	2003	4	2003	2	200304
80	644	4/5/2003	7	Saturday	5	95	14	April	4	2	2003	4	2003	2	200304
81	645	4/6/2003	1	Sunday	6	96	15	April	4	2	2003	4	2003	2	200304
82	646	4/7/2003	2	Monday	7	97	15	April	4	2	2003	4	2003	2	200304
83	647	4/8/2003	3	Tuesday	8	98	15	April	4	2	2003	4	2003	2	200304
84	648	4/9/2003	4	Wednesday	9	99	15	April	4	2	2003	4	2003	2	200304
85	649	4/10/2003	5	Thursday	10	100	15	April	4	2	2003	4	2003	2	200304
86	650	4/11/2003	6	Friday	11	101	15	April	4	2	2003	4	2003	2	200304
87	651	4/12/2003	7	Saturday	12	102	15	April	4	2	2003	4	2003	2	200304
88	652	4/13/2003	1	Sunday	13	103	16	April	4	2	2003	4	2003	2	200304
89	653	4/14/2003	2	Monday	14	104	16	April	4	2	2003	4	2003	2	200304
90	654	4/15/2003	3	Tuesday	15	105	16	April	4	2	2003	4	2003	2	200304
91	655	4/16/2003	4	Wednesday	16	106	16	April	4	2	2003	4	2003	2	200304
92	656	4/17/2003	5	Thursday	17	107	16	April	4	2	2003	4	2003	2	200304
93	657	4/18/2003	6	Friday	18	108	16	April	4	2	2003	4	2003	2	200304
94	658	4/19/2003	7	Saturday	19	109	16	April	4	2	2003	4	2003	2	200304
95	659	4/20/2003	1	Sunday	20	110	17	April	4	2	2003	4	2003	2	200304
96	660	4/21/2003	2	Monday	21	111	17	April	4	2	2003	4	2003	2	200304
97	661	4/22/2003	3	Tuesday	22	112	17	April	4	2	2003	4	2003	2	200304
98	662	4/23/2003	4	Wednesday	23	113	17	April	4	2	2003	4	2003	2	200304
99	663	4/24/2003	5	Thursday	24	114	17	April	4	2	2003	4	2003	2	200304
100	664	4/25/2003	6	Friday	25	115	17	April	4	2	2003	4	2003	2	200304