Create a formula that returns the current day of the week.

To complete this challenge, use some of the strategies and function you learned in this unit to return the day of the week as a text string.

• The formula should be on the Contact object
• The formula should be of return type Text
• The formula should be named 'Day of the Week' with the resulting API name 'Day_of_the_Week__c'.
• The formula should return the day of the week as a string—”Monday,” “Tuesday,” and so on

1) Create one custom formula field on contact object of type text and enter the below formula.

CASE(MOD(Today()- DATE(1900,1,7), 7), 0, 'Sunday', 1, 

'Monday',2,'Tuesday',3,'Wednesday',4,'Thursday',5,

'Friday',6,'Saturday','error')