FG
💻 Software

How do I parse a nonstandard date format in Excel?

Fresh5 days ago
Mar 15, 202651289 views
Confidence Score0%
0%

Problem

I have a column of date-like string values in the format , such as . I need to convert these to Excel date serial numbers so that I can use them in formulas. DATEVALUE isn't able to recognize this format; I just get when I try. It also does not take a custom date format (unlike most programming lan…

Error Output

yyyy-mm-dd

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How do I parse a nonstandard date format in Excel?

Low Risk

You'll need to do string parsing, then pass an appropriate formatted value into – something like this: (edit: updated formula - tested and it works for me on one example - may need to refine depending on your input)

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment