Define holiday in Named range and use it any where in the workbook

My HR Friend:

HR prepares the time office report for all the employees in a excel sheet.  He is using the Networking days function to find the working days in the month and calculates the salary for the month.  He is manually entering the holidays in the formula and finding difficult that the holidays not accounted because of format error while typing it in the function.

My Solution is:

One can create a named range in the beginning of year and save the holidays a 'Named Range' and call it to the Networkdays function. The steps for creating the named ranged is given below;

STEPS
Step 1:	Type your name holidays as a column of dates in A6:A13
Step 2:	In a blank cell,type=A6:A13.Do not press enter instead,press the F9 key.
	{40923;40934;41013;41030;41136;41164;41192;41226}
Step 3:	Press ctrl+C to copy the array to the clipboard.
Step 4:	Press Esc to exit formula Edit mode.The formula disappears
Step 5:	Visit the name dialog box (Formula->Define name)
Step 6:	Type Holidays as the name.
Step 7:	In the refes to Box,clear the current text.Type an equals sign.Press Ctrl+V to paste the array of dates to the box.Click ok.