This formula uses the “dddd” custom date format to return the weekday name for any given date. In our example, TEXT(“2030-01-01″,”dddd”) will return “Tuesday” since January 1st 2030 falls on a Tuesday. We can also use the “ddd” custom format to return abbreviated weekday name: Mon, Tue, Wed, Thu, Fri, Sat & Sun.