Forum Discussion
Numerical Dates to Days
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.