It’s so easy to just miss something. A date function which is off.
Missing something in excel is a big deal for a firm which is mean to do it - and it will always happen. And that’s the experts.
I’m betting Someone was too tired, and uninterested and just followed the script.
Hopefully that experience put the fear of God into some analyst and associate.
Pretty much the only thing that I can rely on when it comes to modeling.
Knowing that someone is as terrified as I am and has put the work in to not be embarrassed.
And let’s agree - it is work.
I remember seeing a date function used by another firm for the first time.
It too me at least an hour to decipher it.
It was cool, I learnt a lot. But it takes time.
Regexes are cool, and I guess people will be learning a lot.
If so, did it at least have embedded VB or was it all cell logic?