Formatting General Text to Date

[acool]

Hi Everyone,

I am currently have a list of dates that are provided in General Format. What I would like to do is format these values to XX/XX/XXXX Date Format. While I am not provided the with day, I would like each "Day" Value to display as the first of the month. I have provided an example of what I am trying to achieve on in cell B2. Any help would be greatly appreciated. Thank You!

 

[awoohaw]

Try:

=date(textbefore(A2,"-"),textafter(A2,"-"),1)

 

[programsam]

Try this...

=DATEVALUE(RIGHT(A2,2)&"/1/"&LEFT(A2,4))

 

[Fluff]

Another option

Fluff.xlsm
	A	B
1
2	2022-01	01/01/2022
3	2022-02	01/02/2022
Master

Cell Formulas
Range	Formula
B2:B3	B2	=TEXT(A2&"-01","yyyy-mm-dd")+0

 

[Rick Rothstein]

Noting that you are using XL365 - assuming you have your date-stubs in cells A2:A99, this single formula will spill the serial date numbers for all of the values (so you will have to format the cells to display as needed)...

=(A2:A99&"-1")+0