Make a calendar in Excel

General

Here’s a nifty formula that’ll create a calendar in Excel:

Make a calendar in Excel:

=IF(MONTH(DATE(YEAR(NOW()),MONTH(NOW()),1))
<>MONTH(DATE(YEAR(NOW()),MONTH(NOW()),1)-
(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),1))-1)
{0;1;2;3;4;5}*7 {1,2,3,4,5,6,7}-1),””,DATE(YEAR(NOW()),
MONTH(NOW()),1)-(WEEKDAY(DATE(YEAR(NOW()),
MONTH(NOW()),1))-1) {0;1;2;3;4;5}*7 {1,2,3,4,5,6,7}-1)

To use it:

  1. Copy the formula text to the clipboard
  2. Activate an Excel sheet and select a 7-col by 6-row range
  3. Press F2
  4. Press Ctrl V to paste the formula into the active cell
  5. Press Ctrl Shift Enter (to make it a multicell array formula)
  6. Format the cells using the “Date” number format.