Forum Discussion
Numerical Dates to Days
Hi Daniel,
It depends on your needs. If you'd like only to show your dates as weekdays that's what you did.
If you'd like to receive weekdays numbers to perform with them some calculations use WEEKDAY function.
If you'd like to have the text with weekdays names use TEXT function where second parameter will be as in your custom formatting.
There is a column of numbers, formatted as dates like 7/21/17. The second column, with the heading, Days, has blank cells. The instructor copied the cells of column 1 into column 2, then applied a Text Function to change the numbers in column 2 to the days of the week, from top to bottom.
I tried using his formula, then the Formula builder, and finally, the step-by-step procedure I picked up from Microsoft support outlined in my first message. None of the routines worked.
I have attached the Excel file.
Maybe my copy of Excel, or the Mac version simply doesn't work the way all the solutions I've found have described. For example, I found a solution at this URL:
https://www.extendoffice.com/documents/excel/814-excel-change-date-to-day-of-week.html
After selecting a column of dates, I couldn't bring up a context menue by right clicking on the column.
Does anyone here have experience working with Excel 15.33 on a Mac?
Hi Daniel,
I have no Mac version, but all such transformations shall work the same way on all platforms.
It looks like in your first column (Date) dates are entered as text, not as numbers (in Excel dates are numbers where by default 1 is Jan 01, 1900 for Windows and Jan 01, 1904 for Mac). Applying formatting you may receive different representation of such numbers (as full dates, weekdays, etc.).
When you enter into the cell the date in your default regional format Excel automatically applies date format for such cell (if you didn't force another one).
You may see visually do you have text or number/date in your cell - in first case values arealigned to the left side of the cell, in second one - to the right. Another simple test in any empty cell enter the formula =<cell with date>+1. If the result an error when you have text.
Please check the second sheet in the attached file if it works on your Mac.
