hollyanneu2
New Member
- Joined
- Feb 12, 2013
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
For the love of god, 365 is driving me NUTS!
I have a column with a Date Time format and I added a column next to it to give me the day but nothing is working...
Here's what I done:
I need the day in a separate column from the original Date/Time format. Any solution to that???
I have a column with a Date Time format and I added a column next to it to give me the day but nothing is working...
Here's what I done:
- =Text(E2,"dddd") >>> data validation error because of the "hidden time"
- the Custom does not have "dddd" listed
- =MONTH(E2) & "/" & DAY(E2) & "/" & YEAR(E2) to get rid of the time part, then copied and pasted the date as value in another column to get rid of the "hidden" time value and then tried =Text(E2,"dddd")
- I tried using the *Wednesday, March 14, 2012 format and then tried to separate the day from the date/time using the Text to Column and oddly I only see the Date/Time format in the Preview of selected data box....
I need the day in a separate column from the original Date/Time format. Any solution to that???