MS Excel / VBA help thread

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

•

NotThamesWater

=date(right(a1,4), left(a1,3),1)

the apostrophe is ignored

if it isn't ignored:
=date(mid(a1,2,2), left(a1,3),1)

•

aggi in reply to @NotThamesWater

I don't know why as it always makes it more complicated but whenever I do this kind of thing I always use the end of the month rather than the start.

About

Avatar for NotThamesWater @NotThamesWater started