text function in Excel 1 Excel   get the day or month name from a date

Often you will want to extract a month or day of the week from an Excel date. This is extraordinarily easy to do using the text function.

To get the name of the day of the week from a date in, for example, cell A1 type this into another cell:

= TEXT(A1,”dddd”)

This will give you the full day name spelled out such as Monday or Tuesday.

If you want a three character name use:

= TEXT(A1,”ddd”)

The same basic formula can be used to get the month of the year from a date. Use this to get the month name spelled out in full:

= TEXT(A1,”mmmm”)

Use this to get the month of the year spelled out in three characters:

= TEXT(A1,”mmm”)

and this for a single letter month:

= TEXT(A1,”mmmmm”)

This formula can be easily constructed and copied down a column of dates to extract just the information you want very quickly and easily.

The Excel help file has some information about the different formats you can use to extract data using the TEXT function.

text function in Excel Excel   get the day or month name from a date

Helen Bradley

Related posts:

  1. Calculating elapsed time in Excel
  2. How old are you?
  3. Conditional formatting with Date ranges
  4. Converting Imported data in Excel
  5. Excel: Monthly totals for daily data