Excel Text Date

I need to convert an Excel text date in the format of Day, Date, Year.
Monday, January 04, 2016
Tuesday, January 05, 2016

Thanks

Microsoft Excel

Last Comment

shieldsco

8/22/2022 - Mon

Jon Covalt

3/1/2016

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

Rgonzo1971

3/1/2016

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

aikimark

3/1/2016

please post a sample workbook

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

shieldsco

3/1/2016

ASKER

Rgonzo1971 - formula returns invalid