Microsoft Office Tutorials and References
In Depth Information
Working with Multicell Array Formulas
This version of the formula displays the days from the preceding month and the next month, as
shown in Figure 15-14. I used conditional formatting to display these dates in a lighter color (see
Chapter 19 for more about conditional formatting).
Figure 15-14: A simpler version of the array formula displays dates from the preceding and subsequent