Hey guys, is there a way in Smartsheet to return the day of the week based on a date entered?

Options

Example: Cell 1 contains the date as "8 April 2022". Cell two returns the text "Friday".

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @Marnus Ehlers

    Try this:

    =IF(WEEKDAY([Your Date]@row) = 1, "Sunday", IF(WEEKDAY([Your Date]@row) = 2, "Monday", IF(WEEKDAY([Your Date]@row) = 3, "Tuesday", IF(WEEKDAY([Your Date]@row) = 4, "Thursday", IF(WEEKDAY([Your Date]@row) = 5, "Friday", IF(WEEKDAY([Your Date]@row) = 6, "Saturday"))))))

    Be sure to edit the formula to insert your actual column name

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!