WRITING AND SOFTWARE BY IAN SHARPE

Excel diary/planner page generator

Print diary/planner pages from Excel, two months per page

I built this Excel spreadsheet at a time when I found it useful to have a printed planner. The output went into a ring binder so I had a perpetual diary. It is set up for A4 but is easily massaged to fit other paper sizes.

These grabs of the print preview don't show the true quality. It looks much cleaner on paper.

Image showing part of a sample planner page

Image showing a full sample planner page

Instructions are contained in the workbook but there's nothing to it: enter the year at the head of the first column, and the first month number in cell B3. This cell is formatted white-on-white so the number is invisible. The page will automatically update when the year or month are changed.

Downloads

Version 2.1, November 2014

Compatibility Most Excel versions

Description / note Diary page maker spreadsheet

Professional services

I offer professional services in software development, databases, data manipulation and writing. Find out more at IanSharpe.com.

OFFER - Get $10 to spend on a DigitalOcean VPS

IanSharpe.com and other sites I manage are hosted at DigitalOcean. I am happy to recommend this company for Linux VPS hosting.

I get a commission if you open an account through this link and stay a while. DigitalOcean will credit $10 when you add a payment method. That gets you a generous slab of Linux-based VPS hosting for nothing and helps support this site.

All material © 1986–2015 Ian Sharpe. Nothing may be reproduced or made available for download elsewhere without permission