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