# Day of the week

Options
edited 05/10/24

What formula do I need to turn a date in one column to the day of the week in another

So what I'm after is 09/06/22 = Thursday and so on

I'm new to Smartsheets, but I can do this in excel. Please help I think I'm goning nutts

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this. (change the column name if needed)

```=
IFERROR(
IF(WEEKDAY(Date@row) = 1, "Sunday",
IF(WEEKDAY(Date@row) = 2, "Monday",
IF(WEEKDAY(Date@row) = 3, "Tuesday",
IF(WEEKDAY(Date@row) = 4, "Wednesday",
IF(WEEKDAY(Date@row) = 5, "Thursday",
IF(WEEKDAY(Date@row) = 6, "Friday",
IF(WEEKDAY(Date@row) = 7, "Saturday"))))))), "")
```

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

Hi @Jo Pearson,

as André already posted an example of the usage where your dates can be found in a column named "date" and the WEEKDAY formula lives in another column to show the day of the week, maybe you could post a screenshot so we can see?

Greetings

Stefan

PS: André also incorporated an IFERROR function in his example to cater for empty cells in the "date" column :-)

Smartsheet Consulting, Solution Building, Training and Support.

Projects for Processes and for People.

• ✭✭✭✭✭✭
Options

Hi @Jo Pearson,

I think the WEEKDAY function is your friend ;-)

Hope this helps

Stefan

Smartsheet Consulting, Solution Building, Training and Support.

Projects for Processes and for People.

• Options

Thanks Stefan, I've tried and it doesn't work

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Try something like this. (change the column name if needed)

```=
IFERROR(
IF(WEEKDAY(Date@row) = 1, "Sunday",
IF(WEEKDAY(Date@row) = 2, "Monday",
IF(WEEKDAY(Date@row) = 3, "Tuesday",
IF(WEEKDAY(Date@row) = 4, "Wednesday",
IF(WEEKDAY(Date@row) = 5, "Thursday",
IF(WEEKDAY(Date@row) = 6, "Friday",
IF(WEEKDAY(Date@row) = 7, "Saturday"))))))), "")
```

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

Hi @Jo Pearson,

as André already posted an example of the usage where your dates can be found in a column named "date" and the WEEKDAY formula lives in another column to show the day of the week, maybe you could post a screenshot so we can see?

Greetings

Stefan

PS: André also incorporated an IFERROR function in his example to cater for empty cells in the "date" column :-)

Smartsheet Consulting, Solution Building, Training and Support.

Projects for Processes and for People.

• ✭✭
Options

Just tried Andree's post and it worked perfectly. Thanks!

• Options

Hi, i'm new to smartsheets and was looking for a solution like this but am unsure how to implement it on my sheet…
I assume I need a column with the date to draw from but how and where would I use Andre's solution?

• ✭✭✭✭✭✭
Options

Hi,

I hope you're well and safe!

You're correct, and then you'd add my formula in a so-called helper column.

Make sense?

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

I'm still working on this… Let me give some context of what i'm trying to do.

I am working on a dashboard with a frame that shows assigned tasks for a user. I'd like this to change based on the day of the week. We have a series of reports that displays these for each day of the week. Basically I would like the frame to automatically load a specific report depending on the day of the week. So Monday the dashboard frame loads report A and Tuesday Report B and so on. I work in research animal husbandry and we use smartsheets to create our technician animal room assignments and our techs open these reports manually now from links posted on the current dashboard.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!