ExcelBanter - Q: date convert

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Q: date convert (https://www.excelbanter.com/excel-discussion-misc-queries/52312-q-date-convert.html)

JIM.H.

Q: date convert

Hello,
How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a
formula?
Thanks,

Arvi Laanemets

date convert

Hi

With date in A1
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
and format in any valid date format

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )

"JIM.H." wrote in message
...
Hello,
How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a
formula?
Thanks,

Roger Govier

Q: date convert

Hi Jim

Try
=MID(A1,5,2)&"/"&LEFT(A1,4)&"/"&RIGHT(A1,2)

Regards

Roger Govier

JIM.H. wrote:
Hello,
How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a
formula?
Thanks,

Gary76

Q: date convert

Assuming the date is numeric, something like:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

HTH

"JIM.H." wrote:

Hello,
How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a
formula?
Thanks,

All times are GMT +1. The time now is 12:43 PM.