Date format

[MikeMc]

Is there automatic date format I can use to display day of week and date like you can in sheets/excel. 

I want to keep the type as date to do calulations, but am looking for the following format on screen:   "Mon 13 Mar 23" 

Not too fused about 23 or 2023 , Mar or March, but day as Mon/Tues etc is important

I have tried using List func  List  ("Mon", "Tues"....  and concatinating with "day" , "dd/mm/yy" but the result then needs to be a text item and I need date type to calaualte from!

[diogolupcosta]

It works with switch() expressions

[MikeMc · Accepted solution]

Hi

sorry for late reply - been on  holiday.

I could not get your soluition to work,  but instead have found this works 

1. Create a virtual column(Date)  with the formula "TEXT([Start], "ddd d MMM yy")".
2. In the UX  Sort by = "[start]" and Group by = "[Date]".

Thanks  for your interest.