Generic Formula

What It Does

This formula will return the weekday for a given date.

How It Works

The TEXT function will return a text string based on any custom format. 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.

How To Get The Weekday Name From A Date - 45