
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 13, 2022 05:39 PM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 03:29 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 02:33 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 03:29 AM
You can also use
DATETIME_FORMAT({date}, 'dddd')
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 03:50 AM
What! I didn’t know this was a thing; this is much simpler and I’m definitely using this in the future instead

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2022 10:11 AM
Glorious! Thanks so much!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 25, 2023 02:28 PM
Hi how can i show day of next week ?
