# Format date to day of the week(Mon - Sun

**URL:** <https://community.glideapps.com/t/format-date-to-day-of-the-week-mon-sun/81433>\
**Category:** Ask for Help\
**Created:** [April 19, 2025, 1:53pm UTC](https://community.glideapps.com/t/format-date-to-day-of-the-week-mon-sun/81433 "2025-04-19T13:53:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\
**Post date:** [April 19, 2025, 1:53pm UTC](https://community.glideapps.com/t/format-date-to-day-of-the-week-mon-sun/81433/1 "2025-04-19T13:53:51Z")

</div>

Auto-tag the day of the week (Mon–Sun)

how do l implement the "Auto-tag the day of the week

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 19, 2025, 2:22pm UTC](https://community.glideapps.com/t/format-date-to-day-of-the-week-mon-sun/81433/2 "2025-04-19T14:22:04Z")

</div>

Do you mean converting a timestamp to its weekday equivalent?

---

<div class="post-metadata">

**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\
**Post date:** [April 19, 2025, 2:22pm UTC](https://community.glideapps.com/t/format-date-to-day-of-the-week-mon-sun/81433/3 "2025-04-19T14:22:48Z")

</div>

Yeah like 4/19/2025 convert to saturday

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 19, 2025, 2:36pm UTC](https://community.glideapps.com/t/format-date-to-day-of-the-week-mon-sun/81433/4 "2025-04-19T14:36:06Z")

</div>

Use a math column with the formula `Weekday(Date)`  
That will give you a number representing the day of the week, which you can then convert to the day name.

One way to do that is with an if-then-else column, but my preferred method is using a single value column, selecting `N` from start of a list of names, where `N` is the weekday number.

Another way is using the Format Date column, but I don’t recommended that as it doesn’t always work reliably.

---

<div class="post-metadata">

**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\
**Post date:** [April 19, 2025, 2:57pm UTC](https://community.glideapps.com/t/format-date-to-day-of-the-week-mon-sun/81433/5 "2025-04-19T14:57:27Z")

</div>

That’s right. l totally forget that math formula.  
Thank you Darren

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 26, 2025, 2:58pm UTC](https://community.glideapps.com/t/format-date-to-day-of-the-week-mon-sun/81433/6 "2025-04-26T14:58:24Z")

</div>

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