I have a column of date-like string values in the format
yyyy-mm-dd, such as
2011-Sep-13. 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
#VALUE! when I try. It also does not take a custom date format (unlike most programming languages).
How can I convert arbitrary date formats into Excel date values?