# Indicate dates as day of week
**URL:** https://community.glideapps.com/t/indicate-dates-as-day-of-week/34979
**Category:** Ask for Help
**Created:** [November 23, 2021, 7:37pm UTC](https://community.glideapps.com/t/indicate-dates-as-day-of-week/34979 "2021-11-23T19:37:56Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@fluittsolutions](https://community.glideapps.com/u/fluittsolutions)
#### Post date: [November 23, 2021, 7:37pm UTC](https://community.glideapps.com/t/indicate-dates-as-day-of-week/34979/1 "2021-11-23T19:37:56Z")
I’ve seen this addressed in older posts but, I think that was before Glide added the new computed columns…
In my google sheet, I used an Excel formula of
=TEXT(D2,“dddd”)
to format the date in cell D2 to the weekday (Monday). However, as I add rows, I have to copy the formula down into the new rows.
I prefer to build this as a glide computed hyperformula column but, I’m getting unexpected results. I have used the same excel formula =TEXT(A1,“dddd”) and indicated A1 to be my Start Date column. The result is that some fields are blank and others have four digit numbers that don’t seem to relate to the days of the week.
I appreciate any ideas you may have.
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [November 23, 2021, 7:45pm UTC](https://community.glideapps.com/t/indicate-dates-as-day-of-week/34979/2 "2021-11-23T19:45:33Z")
Hola @fluittsolutions
Take a look at this thread:
> [@Extracting the "day of the week" from the date](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/30189):
>
> Hi fellow gliders, If I have a known date and you display it in the long format, you are given the day of the week as well. Is it possible to display on the day of the week and not any other information e.g. display only “Monday” or “Tuesday”. This I would want to use to relate to another table if possible… Thanks