Date formats - is it possible to show a date ...

[Marlene_Willia1]

Date formats - is it possible to show a date as ddd dd mmm as in Mon 5 Jul? I have set my spreadsheet to show this.

[Levent_KULACOGL]

@Marlene_Williamson1

=CONCATENATE( IFS( WEEKDAY([Date])=0,“Sun”, WEEKDAY([Date])=1,“Mon”, WEEKDAY([Date])=2,“Tue”, WEEKDAY([Date])=3,“Wed”, WEEKDAY([Date])=4,“Thu”, WEEKDAY([Date])=5,“Fri”, WEEKDAY([Date])=6,“Sat” )," “, DAY([Date]),” ", IFS( MONTH([Date])=1,“Jan”, MONTH([Date])=2,“Feb”, MONTH([Date])=3,“Mar”, MONTH([Date])=4,“Apr”, MONTH([Date])=5,“May”, MONTH([Date])=6,“Jun”, MONTH([Date])=7,“Jul”, MONTH([Date])=8,“Aug”, MONTH([Date])=9,“Sep”, MONTH([Date])=10,“Oct”, MONTH([Date])=11,“Nov”, MONTH([Date])=12,“Dec” ) )

[Marlene_Willia1]

Thank you so much

[Levent_KULACOGL]

@Marlene_Williamson1 you’re welcome

[Aleksi_Alkio]

How about the long format?

[Marlene_Willia1]

@Aleksi_Alkio not wanting the year to show…

[Aleksi_Alkio]

Gotcha

[Marlene_Willia1]

I am now wanting to use my new day column to group events as in an agenda, but of course, as it is text, it is not grouping in date order. Is there a way around this? I have sorted in Date order but that is within groupings.

[Marlene_Willia1]

Partially solved - put the Day([Date] first in the Concatenate but won’t be very good at the end of the month.