Would you like this in excel formula, VBA, or python?

It can be done in all. You’re only proving the other poster’s point. Excel isn’t necessarily the best option for tech literate people but given the tech illiteracy of many offices, it isn’t surprising they use excel for stuff like this.