Setting up columns for dates and entries
Okay sooo. Last lesson we talked about what's worth tracking and what belongs on paper. If you decided something's worth a sheet, this is where we actually build the thing.
We're starting simple. Just two columns: date and entry. That's it. Not five columns, not a color-coded system, not a tab for every possibility you can imagine. Just enough structure to hold the information without getting in your way.
Setting up the columns
Open a blank sheet. In A1, type "Date." In B1, type "Entry" or "Item" or whatever word makes sense for what you're tracking. If you're tracking something with a number attached, like spending or hours, add a C1 for "Amount."
That's your header row. Bold it if you want, doesn't matter much, but it does help your eyes find the top of the sheet later.
Now here's the thing about the date column specifically. Don't type dates as text like "March 3rd" or "3/3." Type them so the spreadsheet recognizes them as an actual date, usually just typing 3/3/2026 and hitting enter does it. You'll know it worked because it'll auto-align to the right side of the cell, that's the tell. Text sits left, numbers and dates sit right. If your date is sitting on the left, something's off and the sheet is treating it like a word instead of a date.
Why does this matter? Because a real date lets you sort chronologically, filter by month, all that. A date typed as text just sits there being a word that looks like a date. It'll fool you until the moment you need it to actually behave.
Entering a row
Under your headers, start entering rows. One row per entry. Date in column A, what happened in column B, amount in column C if you're using it.
Not gonna lie, this is the boring part of the lesson. There's no formula trick here, no orange conditional formatting moment. It's just typing things in, one at a time, as they happen. That's actually the whole system though. A tracking sheet only works if you can put an entry into it in about ten seconds, standing in the kitchen, half paying attention to something else.
An opinion, real quick
You do not need more columns than you'll actually fill in. I see people build a tracking sheet with a column for date, entry, amount, category, notes, mood, weather, whatever, and by week two they're only filling in two of the six. Then they feel like they're failing at their own spreadsheet, which is a very specific and dumb kind of guilt to carry around.
Start with the minimum. Date and entry. Add a column later if you actually find yourself wanting it. Don't build it in advance out of anxiety that you might need it someday.
A note on consistency, not perfection
My birthday and anniversary tracker lives on paper, not in a sheet, in a little notebook I keep by month. It's got a coffee ring on the March page from years ago, before I had kids, back when I apparently drank coffee near open notebooks without a second thought. I've never rewritten that page. It's stained and a little smudged and I've decided that's just what March looks like now.
I bring that up because people sometimes think a tracking system has to look clean to be working. It doesn't. My notebook has a coffee stain and it still tells me when my sister-in-law's birthday is. Your spreadsheet can have a typo in row 12 from three weeks ago and it'll still work fine. The job of the sheet is to hold the information, not to look like a magazine photo.
A couple of practical habits
Enter things close to when they happen. If you wait a week to log five entries from memory, you'll get the amounts wrong and possibly the dates wrong too, and a wrong tracking sheet is worse than no sheet because you'll trust it anyway.
Keep your date format consistent. Pick month/day/year or day/month/year and stick with it, the spreadsheet mostly figures out what you mean, but you'll confuse yourself scrolling through a mixed column six months from now.
And turn on autosave if you haven't already, I've said this before and I'll keep saying it. I lost twenty minutes of formula work once to a spilled cup and a laptop that wasn't autosaving, learned that lesson the hard way, don't need you to learn it that way too.
Before next time
Set up your date and entry columns and put in three or four real entries, actual things that happened this week, not made-up test data. Next lesson we'll look at simple ways to pull totals and patterns out of what you've entered.
- C