Forum Discussion
Converting dates to date format
If you value is actual date formatted as "ddd, dd mmm yyyy" when it's nothing to do.
If the value is text which is looks like date, you may convert them to dates with formula like
=DATE( RIGHT(A1, 4), MONTH(1&MID(A1, 9, 3) ), MID(A1, 6, 2))
Applied format doesn't matter.
- Cass_MJul 28, 2023Copper Contributor
SergeiBaklan thank you very much.
this formula has taken off the day text however I would like it to be DD MM YY. Are you able to assist me in getting the date in this format?
Thankyou
- SergeiBaklanJul 28, 2023Diamond Contributor
In addition to HansVogelaar , you may apply any format you wish staying on the cell, Ctrl+1 and here select the format or apply custom one. Here are variant for the same date
Outlook also shall not care which format you use, if only that's Excel file (not csv) and within it you have dates, not texts which looks like dates.
- HansVogelaarJul 28, 2023MVP
Apply the custom number format dd mm yy to the cell(s) with the formula.