Forum Discussion
Function =text(cell,"ddd") fails to convert a date to a day
I am exporting data from a database. Column B contains a date/time and looks like this: 01/01/2017 07:10:59. If you select column B, the column type is "text." I use the "text to columns feature," ...
Hi RJ
If your date is in cell B1 then try this =TEXT(DATEVALUE(B1),"ddd")
Thank you, Wyn but this does not work either.
I feel like there is some sort of hidden formatting or switch that has been toggled when the file is exported from the database. Like I said, sometimes my first attempt and your suggestion do work.
Hi RJ,
Is "dd/mm/yyyy" your regional settings format for the dates?
