Return Day of the Week from Date Field


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?”


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


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.