WEEKDAY

Returns the day of the week for the given date, using 1 for Sunday, 2 for Monday, through 7 for Saturday.

Use

WEEKDAY(date)

Formula Example
Formula Example

WEEKDAY(customdate1__c) returns the day of the week for the given date in customdate1__c