Type a year and a month and the calendar redraws itself: weekends shaded, today blue, other months greyed, and your events written into the right days from a list. Pro adds the whole year on one sheet, a week planner, holidays, and a formulas walkthrough. No macros.
Year, month and week start (Monday or Sunday). A 7 × 6 grid of real dates: the first event of each day under the number, '+N more' when there are several, weekends shaded, today blue, other months greyed. Days, weekend days and events this month counted. Prints on one landscape page.
Twelve months on one sheet from the same settings — weekends, holidays and today highlighted.
Type any date; the week containing it is laid out with holiday names and up to six events a day.
Two hundred rows: date, event, category from a dropdown. Any order. A helper column numbers events that share a date — that's how the grid finds the second one without array formulas.
Year, month, week start, forty holiday rows, event categories.
Fifteen formulas explained: the grid-start arithmetic, the day-name CHOOSE, the event key, the weekend count without NETWORKDAYS.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
Most calendar templates are a picture of one year. This one is arithmetic: the first of the month, stepped back to the start of its week, plus an offset — so every cell in the grid is a real date and the whole thing redraws when you change the year or the month. Weekends shade themselves, today turns blue, the days that belong to August or October go grey.
Events live in a list — date, text — and appear under the right day. Two on the same day? The first is shown and the rest are counted, and the Week sheet lists them all.
The Year sheet lays out twelve months on one printable page from the same settings. The Week sheet takes any date and shows that week with up to six events a day. Holidays come from a list on Setup: pink on Month and Year, named in the day, named on Week. The Events sheet grows to two hundred rows with a category dropdown.
Finding “the second event on the 15th” usually needs an array formula, which Numbers and older
Excel handle differently. Instead, the Events sheet numbers events that share a date and builds
a numeric key — date × 10 + number — so a plain INDEX/MATCH finds the first, second or sixth
event. Day names come from CHOOSE(WEEKDAY(…)) rather than TEXT(…,"ddd"), which changes
with the app’s language. Every one of these is on the Formulas sheet.
The build recalculates the workbook in LibreOffice and in a second, independent engine and compares forty-three values — grid start, day names, the text under specific days including the holiday and the “+1 more”, the counts, the week lookups, the year blocks — against numbers computed outside Excel.
First release
Type any date and the week lays itself out: seven day columns with real dates, fifteen time slots from the hour you start, weekends shaded, today highlighted. Planned and free hours per day are counted. Pro adds a Priorities sheet whose top three show on the week, a Friday Review sheet, and a formulas walkthrough. No macros.
One row per day of the trip: dates from the start date, where you are, what you plan, and what it costs by kind. Daily and trip totals, per day and per person, against a budget. Pro adds a Budget sheet by kind, Bookings with confirmations and what's still to pay, and a Packing checklist. No macros.
Chores down the side, seven days across, and a rotation that says whose turn each one is this week — change the date and the chart re-deals itself. Ticks, minutes and what's still owed are calculated, and each person's share is worked out on minutes, not on the number of chores. Pro adds eight weeks of the rotation printed ahead and a People sheet comparing everyone against a fair share. No macros.