Data format from exported data not recognised

[Jodge25]

Hi,
We I export data from a website it comes in a format of MM DD, YYYY e.g. "March 24, 2023". I would like to turn the data into a pivot table although cant seem to get an easy automated way to get the date into a readable format.

 

[Georgiboy]

Welcome to the forum,

Perhaps you could convert the dates with a formula before you create the PT:

Book1
	A	B
1	March 24, 2023	24/03/2023
2	March 25, 2023	25/03/2023
3	March 26, 2023	26/03/2023
4	January 2, 2023	02/01/2023
Sheet1

Cell Formulas
Range	Formula
B1:B4	B1	=BYROW(A1:A4,LAMBDA(x,LET( ts,TEXTSPLIT(x,{" ",", "}), m,MATCH(INDEX(ts,,1),{"January","February","March","April","May","June","July","August","September","October","November","December"},0), DATE(INDEX(ts,,3),m,INDEX(ts,,2)))))
Dynamic array formulas.