Setting up columns for dates and entries
Last lesson we talked over what is worth tracking and what belongs on paper. If you decided something is worth a sheet, this is where we build the thing.
We start simple. Two columns: date and entry. That is all. Not five columns, not a color-coded system, not a tab for every possibility you can dream up. Only 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 fits what you are tracking. If you are tracking something with a number attached, like spending or hours, add a C1 for "Amount."
That is your header row. Make it bold if you like, it does not matter much, but it does help your eyes find the top of the sheet later on.
Now, a word about the date column in particular. Do not type dates as text, like "March 3rd" or "3/3." Type them so the spreadsheet knows them as a real date; usually just typing 3/3/2026 and pressing enter does it. You will know it worked because it will line up to the right side of the cell, that is the tell. Text sits on the left, numbers and dates sit on the right. If your date is sitting on the left, something is 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 in order, filter by month, all of that. A date typed as text just sits there being a word that looks like a date. It will fool you right up until the moment you need it to behave.
Entering a row
Under your headers, begin entering rows. One row per entry. Date in column A, what happened in column B, amount in column C if you are using it.
I will not pretend otherwise, this is the dull part of the lesson. There is no formula trick here, no orange conditional formatting moment. It is only typing things in, one at a time, as they happen. But that is the whole system. A tracking sheet only works if you can drop an entry into it in about ten seconds, standing in the kitchen, half your attention on something else.
An opinion, quickly
You do not need more columns than you will actually fill in. I see people build a tracking sheet with a column for date, entry, amount, category, notes, mood, weather, and who knows what, and by the second week they are only filling in two of the six. Then they feel as though they are failing at their own spreadsheet, which is a very particular and foolish kind of guilt to carry around.
Start with the least. Date and entry. Add a column later if you truly find yourself wanting it. Do not build it ahead of time out of worry 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. There is a coffee ring on the March page from years ago, back before I had children, back when I apparently set coffee near open notebooks without a second thought. I have never rewritten that page. It is stained and a little smudged, and I have decided that is simply what March looks like now.
I bring it up because folks sometimes think a tracking system has to look clean to be working. It does not. 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 back and it will still work fine. The job of the sheet is to hold the information, not to look like a magazine picture.
A couple of practical habits
Enter things close to when they happen. If you wait a week to log five entries from memory, you will get the amounts wrong and likely the dates too, and a wrong tracking sheet is worse than no sheet, because you will trust it anyway.
Keep your date format the same throughout. Pick month/day/year or day/month/year and stick with it; the spreadsheet mostly works out what you mean, but you will confuse yourself scrolling through a mixed column six months from now.
And turn on autosave if you have not already, I have said this before and I will keep saying it. I lost twenty minutes of formula work once to a spilled cup and a laptop that was not autosaving. I learned that lesson the hard way, and I do not need you to learn it the same way.
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 will look at simple ways to pull totals and patterns out of what you have entered.
- C