Forum Discussion
liz123395
Nov 10, 2023Copper Contributor
Changing date format - August 2023 to 8/1/2023
Hi, I am wanting to change a date format from a text date such as August 2023 or September 2019 to 8/1/2023 or 9/1/2019. So I am looking to change it to not only a date format but also assume th...
- Nov 10, 2023=DATEVALUE(A2)
=TEXT(DATEVALUE(A2),"m/d/yyy")