yogi_Troubleshoot And Fix Problem With Date String In Cell A2

Google Spreadsheet   Post  #2348

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-20-2018

question by: Chris B M

https://productforums.google.com/forum/#!topic/docs/LFkyd3eFCpo;context-place=topicsearchin/docs/category$3Aspreadsheets%7Csort:relevance%7Cspell:false

Date text not being recognized as a date (i.e. Jan 01, 2018)

I'm trying to parse some text that gets automatically imported into my spreadsheet as a date, but that text isn't being recognized correctly. However, when I go to a blank cell and type the exact same value, it's being recognized as a date. Any ideas.

Here are two examples that I can't the spreadsheet to recognize as dates.

M‌a‌r‌ ‌1‌6‌,‌ ‌2‌0‌1‌8‌

=datevalue("M‌a‌r‌ ‌1‌6‌,‌ ‌2‌0‌1‌8‌")

Here's a link to a spreadsheet that shows the issue. Two identical formulas (as far as I can tell) get different results.

https://docs.google.com/spreadsheets/d/1lWxJ4FkQIl3UDHvu0pSa5uHjjABmELtGwsnHfXtIaF8/edit?usp=sharing