Excel Text Date

shieldsco
shieldsco used Ask the Experts™
on
I need to convert an Excel text date in the format of  Day, Date, Year.
Monday, January 04, 2016
Tuesday, January 05, 2016

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
CorinTackNetwork Engineer

Commented:
Presuming you're using a newer version of Excel, select the field that holds the date and click the small arrow in the Number group on the Home tab. (see image)

There, you'll need to select the Date option, if it's not already chosen, and you can then choose the format of the date. This is one of them.
Capture.JPG
Top Expert 2016

Commented:
Hi,

Right-Click the cell Format Cells Custom
and Enter

DDDD, MMM DD, YYYY

and OK

or as a formula

=TEXT(A1;"DDDD, MMM DD, YYYY")

Regards
Top Expert 2014

Commented:
please post a sample workbook
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Author

Commented:
Rgonzo1971 - formula returns invalid

Author

Commented:
Sample file attached
Dates.xlsx

Author

Commented:
CorinTack - do not convert to a real date..
Top Expert 2014
Commented:
Put this formula in a new column and fill down.
=TEXT(MID(A1,FIND(", ",A1)+2,99),"mm/dd/yyyy")

Open in new window

Author

Commented:
Good

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial