Holidays! for Excel Function Tutorial

1. Open/Load the Holidays! Add-In ( vbsHolidays.xla)
2. Start a new workbook (e.g. Book 1).
3. In Sheet 1 of the new workbook, enter the following values to the cells, so it looks like the picture below.

   Cell	Value
   A1	"Year"
   B1	2002

   
    

4. Place the cellpointer in cell B2, and select
   Insert | Function... from the menu.
   
    
5. The Paste Function dialog will appear...
   In the Function Category list (left), select "User Defined".
   This will display ALL the Holidays! functions in the Function Name list (to the right).
   
    
6. Select any of the Holidays! functions in the list, and then select the OK button.
7. Excel will prompt you for any parameters, in this case, we must pass a "Year" (e.g. 2002) or a reference to a cell that contains a Year.
   In our example, cell B1 contains the Year, so enter B1 and select the OK button.
   
    
8. Your worksheet will look similar to the picture below.
   Notice that the Holidays! function returned the number 37370!
   We simply need to Format the cell with a Date format.
   
    
9. Select Format | Cells... from the menu.
   
   
10. In the Format Cells dialog, select the Number Tab, and then Date in the Category list.
    Then select any of the valid Date formats in the Type list (Note that you can also select Custom in the category list, and enter any date format you'd like!).