Name of a day and number of a week

1

I can retrieve a day number (like 1, 2, …) with WEEKDAY({Dates}) but I’d like to display the name (Monday, Tuesday,…), is this possible?

I’d also like to retrieve the week number of a date so that I can sort them by week. Is this possible?

Thanks for your help!

2

Use formula

SWITCH(WEEKDAY({Date}), 0, “Monday”, 1, “Tuesday”, 2, “Wednesday”, 3, “Thursday”, 4, “Friday”, 5, “Saturday”, 6, “Sunday”)

1 Like