Change the date format in the cell

[Zain_inout]

Hi, I would like to change the format from "December 27, 2020 to October 2, 2021" to "27 December, 2020 to 2 October , 2021"??
Please note that the month, date and year can be different in different reports.

Please help me with a code to do this

 

[BigBeachBananas]

Is the value a string or date type?
If date then:
Right click on the cell => Format Cell => Custom =>[$-en-US]d mmmm , yyyy;@

 

[Dave Patton]

T202111a.xlsm
	A	B	C	D	E
1			27-Dec-20	2-Oct-21
2
3		December 27, 2020 to October 2, 2021
4		27 December, 2020 to 2 October, 2021
5
6		27 December, 2020 to 2 October, 2102
7
4b

Cell Formulas
Range	Formula
B3	B3	=TEXT(C1,"mmmm dd, yyy")&" to "&TEXT(D1,"mmmm d, yyy")
B4	B4	=TEXT(C1,"dd mmmm, yyy")&" to "&TEXT(D1,"d mmmm, yyy")
B6	B6	=TEXT(DATE(2020,12,27),"dd mmmm, yyy")&" to "&TEXT(DATE(202,10,2),"d mmmm, yyy")

 

[Zain_inout]

Is the value a string or date type?
If date then:
Right click on the cell => Format Cell => Custom =>[$-en-US]d mmmm , yyyy;@

Hi, thanks for the reply. I am actually looking for a vba code to do the same. The value is a string

 

[Zain_inout]

T202111a.xlsm
	A	B	C	D	E
1			27-Dec-20	2-Oct-21
2
3		December 27, 2020 to October 2, 2021
4		27 December, 2020 to 2 October, 2021
5
6		27 December, 2020 to 2 October, 2102
7
4b

Cell Formulas
Range	Formula
B3	B3	=TEXT(C1,"mmmm dd, yyy")&" to "&TEXT(D1,"mmmm d, yyy")
B4	B4	=TEXT(C1,"dd mmmm, yyy")&" to "&TEXT(D1,"d mmmm, yyy")
B6	B6	=TEXT(DATE(2020,12,27),"dd mmmm, yyy")&" to "&TEXT(DATE(202,10,2),"d mmmm, yyy")

Hi, thanks a lot for this. I am actually looking to write to vba code that can automate this