Microsoft Office Tutorials and References
In Depth Information
Syntax
Excel in Practice: Converting a Holiday Range to an Array
Excel in Practice: Converting a Holiday Range to an Array
The problem with putting the list of holidays in a range on a work-
sheet is that someone might accidentally overwrite or change the
range of holidays.
The syntax for the workdays functions mentions that you can con-
vert the holiday range to an array of serial numbers. To embed the
holidays inside a function, you follow these steps:
11. In Figure 11.47 , select cell B3.
22. In the formula bar, use the mouse to select the characters
E2:E11.
33. Press the F9 key. Excel replaces the selected characters with
the calculated version of those characters. In this case, the
calculation is the array {42005;42023;42051,...}, as shown in Fig-
ure 11.48 .
Figure 11.48.
Figure 11.48. You can remove the holiday cells from the worksheet after em-
You can remove the holiday cells from the worksheet after em-
bedding the array in the formula.
bedding the array in the formula.
44. Press Enter to accept the new formula.
55. You can now delete the holidays in column E.
Search JabSto ::




Custom Search