Hello all,
I have a spread sheet with a column of dates. I need to add another column and convert the date to a day of the week. Does anyone know of formula or VBA to do this automatically?
thx
E.
Hello all,
I have a spread sheet with a column of dates. I need to add another column and convert the date to a day of the week. Does anyone know of formula or VBA to do this automatically?
thx
E.
Last edited by enhydra; 09-05-2011 at 02:10 PM.
Something like =TEXT(A1, "dddd")
or using the custom format dddd
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I'm not sure I understand. I'm trying to convert a whole column of dates to a day of the week in a different column. Would I just add the formula to each cell in the new column.
Attached is an example
thx
E.
Last edited by enhydra; 09-05-2011 at 02:01 PM.
Got it, thanks Mike. Just put what you typed into the cell.
thx
E.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks