Hey guys, is there a way in Smartsheet to return the day of the week based on a date entered?
Example: Cell 1 contains the date as "8 April 2022". Cell two returns the text "Friday".
Answers
-
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!