# Formula for Day of the Week Based on Date

**URL:** https://community.fibery.io/t/formula-for-day-of-the-week-based-on-date/5172
**Category:** Get Help
**Created:** [September 19, 2023, 3:09am UTC](https://community.fibery.io/t/formula-for-day-of-the-week-based-on-date/5172 "2023-09-19T03:09:26Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![lauren.solomon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/lauren.solomon/32/7741_2.png) [@lauren.solomon](https://community.fibery.io/u/lauren.solomon)
#### Post date: [September 19, 2023, 3:09am UTC](https://community.fibery.io/t/formula-for-day-of-the-week-based-on-date/5172/1 "2023-09-19T03:09:26Z")

</div>

Hi all,

I am wondering if there is a way to create a formula that automatically fills a field with the day of the week (Monday, Tuesday etc) based on date field in the same entity.

For example, I have a manual drop down with the day of the week (see below) but I’m hoping to automate it. I’m a bit of a novice user and not very well-versed with formulas so I thought I’d check with the experts 🙂

![Date](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/a79fd765bec3bb701bfbfd27b0c10fa0055ee1ec.png)

Thanks very much!

---

<div class="post-metadata">

### Author: ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)
#### Post date: [September 19, 2023, 9:03am UTC](https://community.fibery.io/t/formula-for-day-of-the-week-based-on-date/5172/2 "2023-09-19T09:03:08Z")

</div>

You can use ‘WeekDayName’ for that 🙂

WeekDayName([Closing date]) will give you the correct output!