Return Day of the Week from Date Field

[Cody_Winchester]

Hello,

I was curious if it’s possible for a formula to return the Day of the Week from Date Field? So, if my Date field reads, “9/27/2022,” is it possible for a formula to understand that this date is, “Tuesday?”

Thanks.

[TheTimeSavingCo]

Edit: Sorry, skip this post and just use kuovonne’s solution below; it’s much better

Hey Cody, yeah, I’d recommend a combination of a WEEKDAY() and a SWITCH()

You can find the set up here

[kuovonne · Accepted solution]

You can also use

DATETIME_FORMAT({date}, 'dddd')

[TheTimeSavingCo]

What! I didn’t know this was a thing; this is much simpler and I’m definitely using this in the future instead

[Cody_Winchester]

Glorious! Thanks so much!

[xiongfeiwaiyin_]

Hi   how can i show day of next week ?