Excel Formula to Convert Date To Weekday Name Or Month Name

How to convert a date to Weekday Name Or Month Name or Year? For example 13-03-2018 to Tuesday or March or 2018. This is one of the most frequently asked queries. So let’s learn an Excel Formula to Convert Date To Weekday Name Or Month Name.

Recommended Reading

Excel Tips

 

Excel Formula to Convert Date To Weekday Name Or Month Name

Excel Formula to Convert Date To Weekday Name Or Month Name or Year

One of the frequently used EXCEL formula to convert date to Weekday Name Or Month Name or year is TEXT Function.

The syntax of text function in excel

TEXT( value, format )

The TEXT excel function is the easiest formula to use for converting Date To Weekday Name Or Month Name. Let’s learn this with an example.

We have a date in cell A2 has 13-03-2018(Date-Month-Year format)

Now we will use TEXT Function

=text(A2, “ddd”) will return “Tue

=text(A2, “dddd”) will return “Tuesday

=text(A2, “mmm”) will return “Mar

=text(A2, “mmmm”) will return “March

=text(A2, “yyyy”) will return “2018

=text(A2, “m”) will return “3

=text(A2, “d”) will return “13

Summary of the examples mentioned above.

A2 is the value or the reference to the cell where date is present.

The second argument of TEXT function accepts format, You can use the format based on your requirement as mentioned below.

  1. “ddd” will return first three characters of the week name.
  2.  “dddd” will return full week name.
  3. “mmm” will return first three letters of the month name.
  4. “mmmm” will return full name of the month.
  5. “yyyy” will return year.

Using TEXT function to convert Date To Weekday Name Or Month Name ideal in the scenario where you want the result to be shown in the different cell. If you just want to convert to the same cell, then format cell will be the best option.

 

0 comments… add one

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.