Microsoft Office Tutorials and References
In Depth Information
Tip 40: Displaying a Live Calendar in a Range
5. Select the range B4:H9 and choose Home ➜ Number ➜ More Number formats to display the
Number tab of the Format Cells dialog box.
6. In the Format Cells dialog box, choose Custom and enter the following custom number
format (which displays the day only) in the Type field:
7. Adjust the column widths and format the cells the way you like.
Change the date and year in cell B2, and the calendar updates automatically. After creating this
calendar, you can copy the range to any other worksheet or workbook.