Converting Text to Date

[acool]

Hi Everyone, I am currently trying to convert text in column A to date Format "YYYY-MMM" in proper format to pull for my pivot tables. Any help would be greatly appreciated. Thank You!

 

[DanteAmor]

In column B you have the date, if you want another format, you can simply change it in the cell formats.

Libro1
	A	B
1	START_DATE	Date dd/mm/yyyy
2	2023-Jul	01/07/2023
3	2021-Oct	01/10/2021
4	2021-Nov	01/11/2021
Hoja1

Cell Formulas
Range	Formula
B2:B4	B2	=DATEVALUE("1"&RIGHT(A2,3)&LEFT(A2,4))

 

[acool]

@DanteAmor Apologies for the confusing. My Values in column A are currently formatted as text. I would like to keep the same Layout (i.e YYYY-MMM) but in proper date format so that it is recognized by my pivot tables

 

[DanteAmor]

Apologies for the confusing. My Values in column A are currently formatted as text. I would like to keep the same Layout (i.e YYYY-MMM) but in proper date format so that it is recognized by my pivot tables

First you must convert that text to a date, that's what the formula is for.
Then you change the format of that date to the format you want, for example:

varios 17nov2023.xlsm
	A	B
1	START_DATE	Date dd/mm/yyyy
2	2023-Jul	2023-jul
3	2021-Oct	2021-oct
4	2021-Nov	2021-nov
Hoja1

Cell Formulas
Range	Formula
B2:B4	B2	=DATEVALUE("1"&RIGHT(A2,3)&LEFT(A2,4))