This function allows you to extract the day of the week from a date time value. For example, if you have the date time 2005-08-08 23:30:00 and apply the extract day of week function, you would get a new column with the text value “Monday”. Please note that in order to successfully extract the day of the week, your date time cell must be in the correct date time format. To convert or change data types, please see Change Data Type: Convert A Column.

See this video for more information on Extracting the Day of the Week in Gigasheet.