Return Day of the Week from Date Field

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.

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()

Screenshot 2022-07-14 at 5.32.50 PM

You can find the set up here

You can also use


DATETIME_FORMAT({date}, 'dddd')

2 Likes

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

1 Like

Glorious! Thanks so much!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.