The following formula shows how to convert a date value to the day of the week. To do this we need to use: DayOfWeek - this takes a date and…