Need to Subtotal or Group by Month?

DateToMonthName

The TEXT function will take any number or date and convert it to text using a particular custom number format.

Try these:

  • =TEXT(A2,”MMMM”) for full month name
  • =TEXT(A2,”MMM”) for 3-letter month abbreviation
  • =TEXT(A2,”DDDD”) for full month name
  • =TEXT(A2,”DDD”) for 3-letter month abbreviation

You can use any valid custom number format, even the ones with three zones for positive, negative, and zero. If the custom number format already contains a quotation mark, change it to two quotation marks:

  • =TEXT(B4,”””Please remit “”$#,##0.00;””Credit balance of “”$#,##0.00;””Zero Balance”””)