Microsoft and Google both have excellent formulas for dates - and are getting there for addresses. Right now - the most useful things you can accomplish in sheets center around what the underlying models are good at - general inference and generation based on text. Anything needing exact outputs should be a numeric formula or programmatic.
Non-exact outputs are actually a feature and not a bug for other use cases - but this takes a bit of use to really see.
Non-exact outputs are actually a feature and not a bug for other use cases - but this takes a bit of use to really see.