0
I have Excel spreadsheets with dates as strings (12/Nov/12 6:59 PM
). If I apply Date / Date Time format to that cells - nothing happens. What I want to do is to make Excel interpret theese values as dates (so, for example YEAR
function works, or I can compare this values in COUNTIFS
(now I cannot, but I need it)). The last thing I've tried is custom format: [$-409]ДД/ММ/ГГ чч:мм AM/PM
(yeah, I am russian user). It does not help too, I am stuck.
How can I make Excel parse it correctly?
Thank you! That helped a lot. I wish I could do this without extra columns, but this solution fit me too. – madhead – 2014-05-26T08:52:42.317
What do you mean? The second formula DOES do it without a helper column. Did you not read the answer? – teylyn – 2014-05-26T10:22:55.787
First approach is more clear to me. I tried and it works. Maybe I made a mistake in second one, but it does not work for
COUNTIFS
. – madhead – 2014-05-26T14:00:55.600