Forum Discussion

Natasha1993's avatar
Natasha1993
Copper Contributor
Jun 19, 2023

How to Change Date/Time Format for whole column

Hello 🙂   I have exported a file from a third-party site where is does not allow me to change the date/time format before downloading.  When I review the file, the column of date/time is not cons...
excel
office 365
training
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jun 19, 2023

Natasha1993 

A possible 365 formula would be

 

= MAP(dateImport,
    LAMBDA(import,
      LET(
        t?, ISTEXT(import),
        v,  TEXTSPLIT(import, {"/"," "}),
        d,  IF(t?, INDEX(v, 2), MONTH(import)),
        m,  IF(t?, INDEX(v, 1), DAY(import)),
        y,  IF(t?, INDEX(v, 3), YEAR(import)),
        DATE(y, m, d)
      )
    )
  )

 

Resources