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.

 

Meet the Author

Hi, I am Aniruddha, an avid blogger since 2008 who likes writing about new gadgets, smartphones and excel. You can find them at www.tech2touch.com. You can also follow me on Twitter @tech2touch or my Facebook page tech2touch. You can subscribe to my YouTube channel tech2touch. Enjoy reading and watching!!!

0 comments… add one

Leave a Comment

Shares