DIY Planner - A Spreadsheet Month - Comments

formulas

jonglass — Mon, 7 Feb 2011 14:49:06 -0500

My download, in LibreOffice, contains a raw date in A1, and the next row contains the formula =DATE(YEAR(A1);MONTH(A1);A3), and the next rows contain different formulas, depending on the row.

That said, as a drop in for the day-per-page, the formatting won't work. The whole day names are too long, and look tiny! Maybe better to just have the person fill in their own shortcuts than to make it language-independent. (I like what you're thinking there, but is it practical?) Alternately, are there abbreviated forms of the names you can use in the formula?

-Jon

Someone else please try this

ygor — Mon, 7 Feb 2011 12:03:27 -0500

When I download it, the "days" do not contain a formula, just a value.
That's not how it should be.
I will fix this to what I originally intended.
-----------------------------------
"I think the surest sign that there is intelligent life out there in the universe is that none of it has tried to contact us." (Calvin and Hobbes/Bill Waterson) ***

A Spreadsheet Month

ygor — Tue, 15 Dec 2009 11:55:19 -0500

Here is a quick and dirty Open Office Calc document with two sheets (one for First Day of the Week is Monday, one for Sunday)

I tinkered this up while playing with the two Chaos spreadsheets and though it worth sharing.

D*I*Y Planner - A Spreadsheet Month - Comments

formulas

Someone else please try this

A Spreadsheet Month

DIY Planner - A Spreadsheet Month - Comments