How do I recreate this custom order number system compatible with both Calc and Excel?

[CRDF]

@Lupp

requires that the date values or their components are entered as literals.

Of course:
B ← order date.