# Chart of averages

**URL:** <https://community.glideapps.com/t/chart-of-averages/48548>\
**Category:** Ask for Help\
**Created:** [September 4, 2022, 11:01am UTC](https://community.glideapps.com/t/chart-of-averages/48548 "2022-09-04T11:01:55Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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:** [September 4, 2022, 4:38pm UTC](https://community.glideapps.com/t/chart-of-averages/48548/6 "2022-09-04T16:38:19Z")

</div>

The method I use to get the weekday from a date is as follows:

- Firstly, I create a column that contains the names of the days of the week (Sun, Mon, Tue, etc). This column can be in any table (I usually have it in a Lookup/Helper table)
- Then I use the following Math formula on my Date column: `Weekday(Date)-1`  
– This returns an integer between 0 and 6, representing the day number of the week, beginning with Sunday == 0
- I then use a Single Value column to fetch the Day name from my list of days, using `N` from start, where `N` is the result of the math column.

A simpler option is to use the Format Date plugin, however that plugin is known to give inconsistent results with Safari on IOS, so I don’t use it for that reason.

---

_[View the full topic](https://community.glideapps.com/t/chart-of-averages/48548)._