Forum Discussion
Numerical Dates to Days
I have a column of dates in the format 7/1/2017, which I need to turn into days of the week. I followed the following procedure, and no change occurred. Select the cells that contain dates that ...
Dear Daniel Leavey,
If the issue has not been resolved as yet, then can you try one of the following formulas.
=WEEKDAY(VALUE(A2),1) or
=WEEKDAY(DATEVALUE(A2),1)
and let me know what result you get.
Change the 'return type' of the weekday as required.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India