1 Be aware that the result will not be a real date

2 Avoid manual alignment as much as possible. By default text is left aligned and numbers right aligned in cells it helps when you get text looking like numbers
3 Is the attached what you need?

Attached Files

Copy of SAMPLE.xlsx (10.2 KB, 7 views)