A	B	C	D	E	F	G	H	I	J	K	L	M	N
2
3		Holidays
4
5
6		Using CreateDate						Business Functions			Excel
7								2003	2004		2003	2004
8		Questions:
9
10		Find 2nd Wednesday in June every year						11 Jun 2003	9 Jun 2004		11 Jun 2003	9 Jun 2004	*
11
12		Find 2nd Wednesday after Easter every year						30 Apr 2003	21 Apr 2004
13
14
15
16		Using NetWorkDaysX
17
18		Questions:
19
20		How many working days between			8 Mar 2003	and	5 Jun 2003	?	64 days		64 days
21
22		How many working days if the weekend falls on a Friday and Saturday?							65 days
23
24		How many working days excluding NYSE holidays?							62 days
25
26		Using WeekNumber and WeekNumberToDate
27
28		Questions:
29
30		What's the week number of this date?					17 Oct 2003		42		42	*
31
32		What's the first day of the week denoted by this week number?							13 Oct 03
33									Monday
34
35
36
37
38
39
40
41		* formula from		CPearson.com
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