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

(Marlene Williamson) #1

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 KULAÇOĞLU) #2

@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 Williamson) #3

Thank you so much

(Levent KULAÇOĞLU) #4

@Marlene_Williamson1 you’re welcome

(Aleksi Alkio) #5

How about the long format?

(Marlene Williamson) #6

@Aleksi_Alkio not wanting the year to show…

(Aleksi Alkio) #7

Gotcha

(Marlene Williamson) #8

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 Williamson) #9

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