This user's spreadsheet thinks his 91-year-old father is 89, and the error is threatening his 19 years of sobriety. That is a darkly funny joke, but it exposes a real problem: the tool is failing at a basic human task because it is stuck in a rigid, number-first logic. Microsoft Excel is not wrong in the way a broken calculator is wrong; it is wrong because it assumes a date is a static value when it is actually a reference point that changes meaning over time. The user did everything right, he used `DATEDIF`, he formatted the cell correctly, he checked his work, and the software still betrayed him.
The practical lesson here is that traditional spreadsheets treat time as a number you type in, not as a living fact that ages with you. When you enter "6/9/34," Excel sees a serial number, not a relationship. It cannot account for the simple truth that a person's age is a function of today, not of the last time you opened the file. That is why the formula returns 89 instead of 91: the software is quietly miscalculating because it is applying a rigid date-parsing rule that does not match the user's intention. The user is not doing anything wrong. The tool is.
This is what happens when a system is built for accountants reconciling ledgers, not for people tracking their father's birthday. The spreadsheet was never designed to understand that "now" changes every day. It was designed to freeze time in a cell. For a user who has been sober for 19 years and just wants a reliable count of his dad's years, that design failure is more than an annoyance, it is a frustration that undermines trust in the tool itself.
The solution is not to learn a more obscure formula or to double-check formatting every time. The solution is to use a tool that understands time as a relationship, not a static entry. An AI-native spreadsheet can look at a date and ask, "What does this mean for the person who entered it?" It can recognize that "6/9/34" is a birthdate and that the relevant calculation is not a raw date difference but a living count that updates itself based on the context of the relationship. That is not a luxury feature. It is the baseline for a tool that claims to help you manage your life. If a spreadsheet cannot tell you how old your father is, it is not a spreadsheet, it is a source of stress. And for a user who has earned 19 years of clarity, that is the last thing he needs.