Day of the week

Jo Pearson
Jo Pearson ✭✭
edited 05/10/24 in Formulas and Functions

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

Best Answers

  • Stefan
    Stefan ✭✭✭✭✭✭
    Answer ✓

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!