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

Marnus Ehlers

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

Kelly Moore

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