This is the exact kind of question that reveals how much friction we've accepted as normal. A user has a column of text, perfectly readable to a human, and their tool cannot make sense of it. The date is there: Friday, March 13. The time is there: 11:11pm. The year is missing, but the user knows it is 2026 because that is the context of the report. Google offers no clean path from that mess to a simple cell value like `3/13/2026`. The user is not asking for a miracle. They are asking for a basic extraction that any human can do in two seconds. The spreadsheet should be able to do it in one.
The practical problem is that legacy tools treat text and data as separate worlds. A string like "Delivered on : Friday, March 13 at 11:11pm at Dock" is just characters. The software sees no date, no time, no pattern, only a long sequence of letters and spaces. To extract the date, you typically need a formula that manually finds "March," counts characters, slices the string, and then hard-codes the year. It works, but it is brittle. Change the format to "13 March" and the formula breaks. Add a different delivery location and the position shifts. The user ends up maintaining a fragile solution instead of getting an answer.
What this means for you is that the barrier is not your skill. It is the tool's inability to learn from context. A human reads that row and instantly knows "March 13, 2026." An AI-native spreadsheet can do the same: it can parse the natural language, infer the missing year from surrounding data or a simple instruction, and output the clean date. You should not have to write a custom parser for every report your boss sends you. You should be able to say "extract the date and add the current year" and have the software understand.
Our opinion is plain: this is a solved problem that the industry has chosen not to solve. The technology to read "Friday, March 13 at 11:11pm" and return a date object has existed for years. What has been missing is a spreadsheet that applies that intelligence without requiring a PhD in regex. The user is not the problem. The missing year is not the problem. The problem is that we have been trained to accept that data cleaning is our job. It should be the tool's job. When a spreadsheet can take that messy string and give you `3/13/2026` with a single command, that is not a luxury. That is the baseline for a tool that respects your time.