Rubin Shrestha
Rubin Shrestha
Blog

Excel won’t recognise text string as a date

by |Published

I’m trying to import a great many dates from an external source which contains the date field as text in the format:-

Sep 23, 2021

Sep 22, 2021

etc.
Unfortunately, Excel does not recognise it as dates.
I’ve tried splitting it into 3 separate columns and then using DATE(Y,M,D) to assign the year month and date columns, but it fails as I think it won’t recognise ‘Sep’ as a month.
What can I do?

You may also like

Published

Low Redis Hit Rate? (20%)

I just checked hit rate of Redis via (https://gist.github.com/kabel/10023961). The hit rate is around %20.x – is this normal? The machine has […]