Here is an easy way to get the name of a date in Excel.

Overview:

Let’s look at the following example using the TEXT Function. By using this function, we can easily grab the day name of a date.

dddd - Monday
dd - Mon
Day Name of a date