Array Formula Calendar
Category: General Files | [Item URL]
- Description: This workbook contains a VBA macro that creates a "live" calendar in a worksheet. The days are displayed using a complex array formula. Change the month and year and the calendar updates. Once the calendar is created, you can copy the cells and paste them to another range, another sheet, or another workbook. The macro simply generates the formulas and is not necessary for the calendar to work.
- Has Macros? Yes
- Download: array formula calendar.xls
Excel Downloads
This section contains free Excel workbooks and add-ins. With a few exceptions, all of these files were developed by me -- John Walkenbach. Some of the files demonstrate useful techniques that you can adapt to your own work. Others are simply for fun.
The files are grouped into three categories: General Interest, For Developers, and Add-Ins. The files may not be compatible with all versions of Excel.
All Downloads
Browse Downloads by Category
Also of Interest
How to download
Most of the download links point directly to Excel files, but a few are compressed ZIP files. For best results: