Convert Date

Hi,

I need to convert number / text : “210506” (21=year 05=month 06=day) to format Date as dd/mm/yyyy
how can i do that ?
Thanks all

This?

CONCATENATE(
  RIGHT([Text], 2),
  "/",
  MID([Text], 3, 2),
  "/",
  ("20" & LEFT([Text], 2))
)

See also:

1 Like

Thanks

1 Like