I'm working with a data set from a public Institution and I've got the bad feeling that it was made by hand. There are a lot of false dates, and they all seem like typos?

Could also be faulty OCR. Either way, I don't get it, because they have those dates in digital form on their website. Wouldn't it have been easier and faster to export them? Instead of having someone typing over 16.000 dates in an Excel Sheet?

I hate to report that I had to look up RegEx to complete my task.

And today I found out that turning on RegEx in LibreCalc meant that another formula was broken so I had to look up the most basic RegEx shit again.

But it's not a problem. Since RegEx is written as if they don't want anybody to understand it, you can just 🦆🦆🥡 your basic question and somebody on stackoverflow will already have asked it

@jollysea strong recommendation for https://regex101.com which has saved me hours of figuring out