Forum Discussion
How to convert dates in excel to common format.
Good day. Please support - I have 2 dates generated from SAP and which come in different formats (columns E & G). I have already tried all possibilities to change it via built-in excel settings, bu...
The created on field appears to contain text. It is human-readable but of no meaning for Excel. Another possibility is to leave the text on the worksheet but to use the date in a formula you could start by converting it to a date
= LET(
createdDate, DATEVALUE(SUBSTITUTE(textDate,".","/")),
createdDate
)or, if you consider that shows too much irrelevant detail on the worksheet you could define a trivial Lambda function
= DATEVALUEλ(textDate)
where
DATEVALUEλ = LAMBDA(textDate,
LET(
createdDate, DATEVALUE(SUBSTITUTE(textDate,".","/")),
createdDate
)
);