number to date

[wenyg]

Hi, what formulas should I put down if I want to convert "102022" to

1) "2022-10" and

2) "2022 Oct"?

[binu_acs · Accepted solution]

@wenyg One way of doing this

[BS_THE_ANALYST]

Hi, here's one way: