Microsoft Office Tutorials and References
In Depth Information
Figure 15-16 shows the results of one of my favorite multicell array formulas: a “live” calendar displayed in a
range of cells. If you change the date at the top, the calendar recalculates to display the dates for the month and
Figure 15-16: Displaying a calendar by using a single array formula.
This workbook is available at this book's website. The file is named array formula cal-
endar.xlsx. In addition, the workbook contains an example that uses this technique to
display a calendar for a complete year.
After you create this calendar, you can easily copy it to other worksheets or workbooks.
To create this calendar in the range B2:H9, follow these steps:
1. Select B2:H2 and merge the cells by choosing Home ⇒ Alignment ⇒ Merge & Center.
2. Type a date into the merged range.
The day of the month isn't important.
3. Enter the abbreviated day names in the range B3:H3.