MS Excel / VBA help thread

You are reading a single comment by @aggi and its replies. Click here to read the full conversation.

•

Drakien
I would nest LEFT and RIGHT:
```
=DATE(B1,RIGHT(LEFT(A1,4),2),LEFT(A1,2))
```
Or use the text-to-columns, but there's probably another reason why you don't want that.

•

aggi in reply to @Drakien
does this do anything that mid doesn't? e.g.
```
=date(b1,left(a1,2),mid(a1,3,2))
```
Edit: that answers my question. I think you've got the date and month the wrong way round (although the original example isn't that clear looking at it which is probably the issue).

@Pifko it is =Date(year,month,day)

About

@aggi started