Hi, Can I return the corresponding day of the...

[Tony_Duggan]

Hi, Can I return the corresponding day of the week from a date in another column?

Thanks

[VICTOR_VERA]

@Tony_DugganYes this can be done,

You can try an IFs expression like this where you want the value to returne:

IFS( WEEKDAY([DATE COLUMN])=1,SUNDAY, WEEKDAY([DATE COLUMN])=2,MONDAY, WEEKDAY([DATE COLUMN])=3,TUESDAY, WEEKDAY([DATE COLUMN])=4,WEDNESDAY, WEEKDAY([DATE COLUMN])=5,THURSDAY, WEEKDAY([DATE COLUMN])=6,FRIDAY, WEEKDAY([DATE COLUMN])=7,SATURDAY)

[Steven_Coile]

switch(weekday([DATE COLUMN]),

1, “SUNDAY”,

2, "MONDAY,

3, "TUESDAY,

4, "WEDNESDAY,

5, "THURSDAY,

6, "FRIDAY,

7, "SATURDAY,

“” )

[Tony_Duggan]

Many Thanks Victor

[VICTOR_VERA]

@Tony_Duggan +Steve Coile

Im pretty sure Coile’s expresion is more efective

[Tony_Duggan]

thanks Steve

[Tony_Duggan]

@VICTOR_VERA

cheers Victor