Get the day name of a date in Excel

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


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

Leave a Reply

MONTH Function

The MONTH function in Excel returns the month component of a specified date as a number between 1-12. Syntax: =MONTH(serial_number)

Read More »


The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.

Read More »

EXACT Function

The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case

Read More »
Scroll to Top